PowerBI Video
24 page views
1671 video views
2024, June 05, Wednesday

How to get and publish Google Analytics data to Power BI

How to get data from Google Analytics in Power BI Desktop and publish it to Power BI Service, ensuring it's updated correctly

We will know the techniques:

🔹Get the data from Google Analytics (GET DATA, ONLINE SERVICE, GOOGLE ANALYTICS, CONNECTOR);
Grant access to Power BI Desktop to visualize Google Analytics data (SEE AND DOWNLOAD YOUR GOOGLE ANALYTICS DATA); 🔹
🔹Retrieve records by selecting metrics and dimensions from the data cube (CUBE, METRICS, DIMENSIONS, TRANSFORM DATA);
🔹Save and Publish report to Power BI Service (SAVE FILE, PUBLISH, WORKSPACES, REPORT, DATASETS); Edit Power BI Service dataset refresh credentials (DATASET, SETTINGS, GATEWAY, EDIT CREDENTIALS);

🔹🔹Create report with visuals suggested by Power BI Service (CREATE A REPORT, AUTO-CREATE)