Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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.
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. 🙂
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.
Regards
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?
So, to get specific to my question, if I would have one table containing all the URLs of all pages, and each URL only appears once in that table, I can use that to build a relationship?
Hi there, curious as to the solution you provided. Similar predicament here.
Thanks!
Hi there, curious as to the solution you provided. Similar predicament here.
Thanks!
Great, then I'm going to try that.
Do you also have an answer to my second question?
Hi @Paulien1989
As far as I know the connection is not live but it does refresh on a schedule that you can't control. I think it's at least daily. There might be some documentation from MS somewhere.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |