1. Home
  2. Knowledge Base
  3. Looker Studio
  4. How To View Your Data In Google Data Studio

Viewing Your Data in Google Looker Studio using the Analytics Canvas data connector

This article is for Analytics Canvas users who have created and published a data set to the Analytics Canvas Looker Studio partner data connector.  

For details on how to get your data into Looker Studio using the Analytics Canvas connector, visit this article.

To view your data once you are in Looker Studio, Click "Add New Data Source", then under Partner Connectors, find Analytics Canvas and click "SELECT".  You will be asked to authorize the Analytics Canvas partner connector.

Image

Analytics Canvas Looker Studio Connector

Once you select and authorize Analytics Canvas, you will see a list of data sources you have been added to.  This contains data sources that you have created and published, as well as those that other people have published and shared with you.

Image

Select a data set, then click "Add" in the bottom right corner. You will then be shown a prompt about adding a dataset called "Analytics Canvas" to your report. 

Unfortunately the name of the data set cannot be set within Analytics Canvas.  To avoid having a series of data sets all called "Analytics Canvas", click the Pencil icon next to the name of the Data Source, then edit the name to be the same name you saw in the list of data sets.  This will make it much easier for you to identify the data set at a later time. 

Image

That's it!  You can now connect one or more charts, tables, or scorecards to this data source.

Troubleshooting & Support

Most often if there is an issue with your connection, the Looker Studio chart or element will display an error message that will help you resolve it.  Here are some other common issues users have when connecting an Analytics Canvas data source to Looker Studio for the first time. 

Data is not showing, or is only partially loaded

If you do not see your data or as much data as you expect, be sure to check the Default Date Range.  The easiest way to see all of the data in your data set is to edit the Default Date Range to show a wide enough period to capture all your data.

⚠️  Looker Studio will automatically apply a 28 day filter based on the Primary Date column in the data set.  

Image

If you change an individual table or chart, it will not be linked to a date range control.  To link your dataset to a date range control, select the dataset and the date control, right click, then select "Group".  Details shown in the video below.

Data is not responding to the Date control

If your data is not responding to the Date range control, it is likely that you either do not have a Date field in your dataset OR you have not set a Date field as the Primary Date Column within the Analytics Canvas control for that table.  

In your canvas, on the Looker Studio block, click edit, then under Primary Date Column, select the date field you wish to use, then click OK

You will be prompted to update the dataset, say "yes" or manually update the dataset after closing the window. 

Image

After updating a dataset in Canvas, the new fields are not shown or removed in Looker Studio

When making a change to the schema of your report, for any existing reports that it is being used in, you must click "Refresh Fields" on the dataset in Looker Studio.

To do this, click on the pencil icon next to the Analytics Canvas dataset in the report. Then click "Refresh Fields" in the bottom left corner.  You report will now have the updated schema. 

Image

My dataset is not updating

Datasets are updated as directed by the user.  Within a Canvas, as you are developing it, you may click the "Write Output" button on the control.   You can also click the Run button to execute the Canvas and publish all outputs. 

If you want your workflows to update on a schedule or on demand via an API call, setup an Automation Package. Directions for automating workflows can be found here on our Knowledge-Base. 

Image

Additional Support 

You should now be able to see all of your data in Google Data Studio.  if you are having any difficulty whatsoever, visit our support page and get in touch.

Was this article helpful?

Related Tutorials/Video