Forum Discussion
Google Analytics: relationships and live connection
Hi everyone!
I only just started with my first job where I have to create dashboards of Google Analytics data using Power BI Desktop (I know about the content pack, but that doesn't provide what I need). There's a couple of things I'm looking to find out, but there's a few of them I cannot really find answers to:
1) How can I create relationships between different reports pulled from Google Analytics? Because it only allows for 7 dimensions at a time to be pulled, I have to create several reports, but I do have to link them back together. I'd figure that the URL of a page would count as a unique value, but Power BI is still unable to detect relationships... I thought about attributing unique IDs to the URLs, but I have no idea how to do that. Does anyone have an idea on how I could accomplish relationships between tables?
2) Is the connection between Google Analytics and Power BI a live one? So if the data in Google Analytics changes over time, are those changes automatically updated in Power BI or do I have to set some kind of schedule?
Happy to hear, thank you!
- You should be able to, yes. If its still not working and you'd like me to take a look. Feel free to pm me a link to a stripped down version of your PBIX file.
Hi Paulien1989,
2) Is the connection between Google Analytics and Power BI a live one? So if the data in Google Analytics changes over time, are those changes automatically updated in Power BI or do I have to set some kind of schedule?
For online service providers like Google Analytics, no user configuration is necessary in order for the dataset to be refreshed on a regular basis on Power BI Service, the refresh is automatic and usually occurs once-a-day. For more details, you can refer to this article. :smileyhappy:
Regards
11 Replies
Hi Paulien1989
Rather than use the content pack. Start with Power BI Desktop and use the Get Data button then choose Online Services and finally Google Anayltics.
From here you should enter your GA credentials and you can pick and choose the data you want. You can create relationships and even bring non GA data into your model
Hi Phil, thanks for replying. I have no trouble importing the data into Power BI and selecting the dimensions/metrics I want in my reports. The problem I've having is creating relationships of the different, seperate reports I pulled in. My question is: how do I set up relationships between tables/queries after the data is already imported?
- Relationships in Power BI need to be 1 to many. So the column used on the table on the 1 side needs to contain unique values.
Hi Paulien1989,
2) Is the connection between Google Analytics and Power BI a live one? So if the data in Google Analytics changes over time, are those changes automatically updated in Power BI or do I have to set some kind of schedule?
For online service providers like Google Analytics, no user configuration is necessary in order for the dataset to be refreshed on a regular basis on Power BI Service, the refresh is automatic and usually occurs once-a-day. For more details, you can refer to this article. :smileyhappy:
Regards
Hi, I am not sure if you have solved the problem. I encountered the same thing, while importing data from GA and connecting two tables keeps giving me the error sign.
Finally I found this step by step video showing how to solve this problem. https://www.youtube.com/watch?v=vAvQ8pCnWDk
Hope this helps. :-)
