PowerBI Video
24 page views
2072 video views
2024, October 23, Wednesday

#124 How to get and publish data from Google Analytics in 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)