WriteBack Data from Power BI to Google drive Excel File through Power Automate

 

Prerequisites:

1.      The column data types in Power BI and the Excel file on Google Drive must match.

2.      Please ensure that you are logged into the connections used in the Power Automate flow.

3.      It is mandatory to create metadata in the Excel file on Google Drive.

Steps to create Power Automate flow:

 

Step 1:

 In Power BI Desktop, click on Power Automate. For reference, please see the screenshot below.

Step 2:

Once the Power Automate visual is opened in the screenshot above, click on the eclipse and

select 'Edit. For reference, please see the screenshot below

 

Step 3:

After clicking on Edit, you will be redirected to Power Automate. For reference, please see the screenshot below.

Step 4:

Click on New Flow and select Instant Cloud Flow. For reference, please see the screenshot below.

Step 5:

Once you click on Instant Cloud Flow, it will automatically create a Power BI Button Clicked action, as shown in the screenshot below.

Step 6:

            Click on Next Step and search for the Compose action, as shown in the screenshot below.

Step 7:

Once you click on Compose, it will prompt you for inputs as shown in the screenshot below. Then, click on Power BI Data.

Step 8:

1.     Click on next Step, Use the Google Drive connector in Power Automate.

2.     Choose "Google Drive" and select "Update File" or "Write to an Excel file".

3.     You will have to authenticate and connect your Google Drive account in Power Automate to access the files on your Google Drive.

 

Step 9:

After completing the necessary details, save the flow and run it as shown in the screenshot below.

Step 10:

               Check the output on Google drive file.