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.
Looker Studio Partner Connector Gallery
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.
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.
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.
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.
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.
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.
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.
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.