How to Update Data in Looker Studio

Nothing kills confidence in a report faster than finding out the data is stale. Looker Studio (formerly Google Data Studio) is an incredibly powerful tool for visualizing your data, but ensuring your dashboards reflect the most current information is up to you. This tutorial will walk you through exactly how to update your data in Looker Studio, from simple manual refreshes to setting up automatic schedules.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How Data Freshness Works in Looker Studio

Before you can update your data, it helps to understand what Looker Studio is doing behind the scenes. Your dashboard doesn't store your data directly. Instead, it connects to your original data sources (like Google Analytics, Google Sheets, or BigQuery) and pulls in the necessary information on a regular basis.

Two key concepts control how often this happens: the data source refresh rate and the report cache.

• Data Source Refresh Rate: This is the primary setting you'll control. It tells Looker Studio how often it should go back to the original source (e.g., your spreadsheet or Google Analytics account) and fetch new information. This can be as frequent as every 15 minutes or as slow as once a day.
• Report Cache: To make your dashboards load quickly, Looker Studio temporarily stores (or "caches") the results of your queries. When you open a report, it first checks the cache. This makes loading near-instant but can sometimes mean you are looking at slightly older data until the cache expires or is manually cleared. The default cache duration is 12 hours.

Your goal is to align these two settings with your business needs so your reports are both fast and accurate enough for your team to make decisions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: The Quick Manual Refresh

Sometimes you just need an immediate update. Maybe you’ve just updated a Google Sheet and want to see the changes in your dashboard right away. The manual refresh is perfect for this one-off situation.

When you're viewing a Looker Studio report, look for the three-dot menu icon in the upper right-hand corner. Clicking it will reveal a "Refresh data" option. Alternatively, you can use the similar refresh icon with a clock next to it.

Clicking this button does two things:

1. It clears the report cache.
2. It forces Looker Studio to send a fresh new query to your data source.

This is the simplest way to get the latest data immediately displayed in your report. It's great for quick checks but isn't a sustainable solution if you need your reports to be updated consistently without your intervention.

Method 2: Set Up an Automatic Refresh Schedule

For most ongoing reports, you’ll want the data to update on its own without you having to click a button every day. You can achieve this by setting the "data freshness" schedule for each data source connected to your report.

Step-by-Step Guide to Setting Data Freshness

Follow these steps to configure your automatic updates:

1. Open your report and enter Edit mode by clicking the "Edit" button in the top right.
2. In the menu bar, navigate to Resource > Manage added data sources. This will open a list of all data sources currently used in your report.
3. Find the data source you want to configure and click Edit in the "Actions" column.
4. You are now in the data source editor. Near the top of the screen, you will see a section labeled Data freshness. Click on it. This is where you set the refresh rate.
5. Click the dropdown menu to see the available update frequencies. Your options will vary depending on the type of data connector you're using:
6. Select the frequency that best suits your needs and click Set. Once you're done, you can close the data source editor tab.

That’s it! Looker Studio will now automatically query your data source at the interval you selected.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Updating Extracted Data Sources

An "extracted" data source is a static snapshot of your data that Looker Studio stores to improve dashboard performance. People often use extracts when working with extremely large or slow-loading data sets. By nature, an extract does not update on its own — it needs to be refreshed manually or on a schedule.

To refresh an extracted data source:

1. Navigate back to Resource > Manage added data sources.
2. Find your extracted data source (it will usually be labeled clearly).
3. Click Edit.
4. At the bottom left of the screen, you'll see a link to Edit the extraction.
5. In this pop-up, you can turn on Auto update and set a schedule (e.g., daily, weekly).

Setting this schedule will ensure your data snapshot is regularly updated with fresh information, bringing the performance benefits of an extract with the accuracy of live data.

Troubleshooting Common Data Update Issues

Sometimes, your data might not update as you expect. Here are a few common issues and how to fix them.

"My Data Is Not Updating!"

If you're looking at your dashboard and the numbers still seem old, run through this checklist:

• Check the Schedule: Did the scheduled refresh time actually pass? If you set it to update every 4 hours, it won't update any sooner than that.
• Check the Underlying Source: This is the most common culprit. Log into the source itself (e.g., open the Google Sheet, check Shopify admin) and confirm that the new data is actually there. Looker Studio can’t show what doesn't exist.
• Check for Authorization Errors: Sometimes, access permissions change or authorization tokens expire. Go to Resource > Manage added data sources. If you see a notification to "Fix Connection" or "Re-authenticate credentials," follow the prompts to reconnect your account.

"Why Can't I Set a 5-Minute Refresh Rate?"

Looker Studio limits the refresh frequency to protect both its systems and the APIs of the services it connects to. Not all platforms can handle being queried every few minutes, so Looker enforces minimum update intervals. You have to work within the options provided by the data connector. If you truly need near-real-time data, you may need a more advanced setup involving a data pipeline into a tool like BigQuery.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Few Pro Tips for Flawless Updates

• Add a "Last Refreshed" Timestamp: Add a text box to your report's header or footer. Type "Data Last Updated:" and then right-click within the text box, select "Insert > Data update time," and choose your format. This tells any viewer exactly how fresh the data is, eliminating confusion.
• Blended Data Sources: If you use a blended data source, remember that it's made up of multiple individual sources. You must set the data freshness schedule for each underlying data source separately.
• Be Mindful of Costs: For tools like BigQuery, you pay for the data you query. Setting a very frequent refresh schedule on a huge dataset can lead to unexpected costs. Match your refresh rate to your business need, not just the fastest option available.

Final Thoughts

Keeping a Looker Studio dashboard current depends on understanding your data sources, setting the right refresh schedule, and knowing how to troubleshoot when things occasionally go wrong. By mastering both manual and automatic updates, you ensure your team's decisions are always based on the most accurate information available.

For many teams, managing data connections, cache settings, and refresh schedules across different BI tools is a significant time sink. This process is often a necessary inconvenience of traditional platforms. At Graphed, we remove this friction entirely. Our platform automatically syncs with your data sources, creating dashboards that are always live and update in real-time. There are no refresh schedules to configure or caches to clear — when new data arrives in your Google Analytics or Shopify store, it's instantly reflected in your dashboards, so you can stop wrestling with settings and get straight to the insights you need.