Automate Power Bi data refresh with Google Sheets
In this episode we'll set up an automated data refresh between Google Sheets and Power Bi. Whenever there's an update of the Google Sheet data source we'll trigger a refresh of the Power Bi dataset (semantic model).
You can get the code used in the video here: https://github.com/DataPandaEU/google...
In a previous episode we used Power Automate to create an automated data refresh between an Excel on SharePoint Online and Power Bi using Power Automate. Power Automate doesn't have a trigger for Google Sheets. That's why we'll use an alternative approach using Google Apps Script.
00:00 - Introduction
00:29 - Load data from Google Sheets
05:07 - Getting started with Google Apps Script
05:50 - App registration in Azure Entra ID
07:30 - Create Client Secret (Certificates & secrets)
08:58 - Set API permissions for our app registration
10:00 - Program refresh logic in Google Apps Script
15:45 - Add app registration to the Power Bi (Fabric) workspace
16:58 - Verify developer settings in the Power Bi (Fabric) admin portal
17:32 - Fix Google Apps Script and verify execution
18:17 - Set On Edit trigger in Google Apps Script
19:43 - Verify execution
20:55 - Make the code more robust and queue changes
#datapanda #datapandaeu