Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've connected a google analytics account but can't find the goals, events or conversion data or fields under datasets. Are those not available? Or can I choose what to import from GA somewhere?
Also, can I import several google analytics accounts and then create a report, dashboard or dataset for the accumulated data of all google analytics accounts together?
Thank you very much.
Hi @Josh,
The Google Analytics content pack and the connector in Power BI Desktop rely on the Google Analytics Core Reporting API. You can go through this article, the Goal Conversions and Event Tracking data are available in API. You can use Google Analytics data source in Power BI desktop, choose desired dimensions and measures to be imported.
Please note we can only get dimensions and measures from the same account one time. If we want to get data from different accounts, we need to create separate query to get data from each account, then use Merge/Append Queries to combine these two tables. See my post in this same thread: Combine multiple accounts GA with advanced editor in one query .
Best Regards,
QiuyunYu
Hi,
I've connected a google analytics account but can't find the goals, events or conversion data or fields under datasets. Are those not available? Or can I choose what to import from GA somewhere?
Also, can I import several google analytics accounts and then create a report, dashboard or dataset for the accumulated data of all google analytics accounts together?
Thank you very much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.