Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
recently I got a task to connect GA to Power BI and create some dashboards. I started connecting and I found out, that I could not find the Account dimension... Am I blind or is there only Google Ads Customer ID that I can load in order to identify the Account the transaction belongs to? We have multiple websites and I am connecting to of ALL. In GA I can set that I want to see the Account. But in power BI I could not find such a dimension.
Of course, I can take the Google Ads Customer ID and replace the value accordingly or create a table with accounts and connect it via the ID... however I am surprised that it cannot be loaded. I thought everything I see in GA can be viewed also in PBI. Or am I wrong?
Solved! Go to Solution.
Hi @zenisekd ,
The Google Analytics content pack and the connector in Power BI Desktop rely on the Google Analytics Core Reporting API.
Reference: Third-party service: Google Analytics connector - Power BI | Microsoft Docs
You can find all of the dimensions and metrics available through the Core Reporting API here. And "Account" dimension is not included.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @zenisekd As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA connector in the data sources list:
After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:
Account name field is available so you won't any problem to query that dimension. There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
Hi @zenisekd ,
The Google Analytics content pack and the connector in Power BI Desktop rely on the Google Analytics Core Reporting API.
Reference: Third-party service: Google Analytics connector - Power BI | Microsoft Docs
You can find all of the dimensions and metrics available through the Core Reporting API here. And "Account" dimension is not included.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
15 | |
15 | |
13 | |
12 | |
11 |