FlowAutoRefresh.md

title	author	date updated	keyword
Auto refresh and publish report to default workspace using Power Automate Desktop	Johnney Cao	2023-04-24	Power Automate Desktop Flow Power BI

Auto refresh and publish report to default workspace using Power Automate Desktop

---

Summary

This page describes how to use Power Automate Desktop to automatically refresh and publish a Power BI report to the default workspace. It includes information on input/output variables, flow variables, and the steps involved in refreshing the report, publishing it to the cloud, and replacing an existing dataset.

---

Variables

Input / output variables

1. FileFolder: Required, Data Type as text
2. FileName: Required, Data Type as text

Flow variables

1. AppProcessId, used in UI elements, Elements.Ordinal = %AppProcessId%

   

2. FullName, Combine FileFolder and FileName above

---

Flows

1. Refresh Power BI Report and Publsih to Cloud

Steps

1. Set variable FullName;

   FullName = %FileFolder%%FileName%.PBIX

2. Run the Power BI report above in default application

3. Wait for the report is open and Refresh button is ready, and then click on Refresh button to refresh data;

4. Wait Refresh popup is closed, and then click on Save button to save the changes;

5. Wait Publish button is ready, and then click on Publish button to start publishing report;

6. Wait Publish to Power BI form is popup, and click on Select button to use the default workspace;

7. Wait Replace this dataset form is popup, and click on Replace button to replace the exiting dataset. On error, skip the step and continue next action;

8. Wait Publishing to Power BI form is popup, and then click on the Report URI to open report from Power BI Service;

   1. Change the attribue below in UI Element which ends with PBIX" in Power BI

   

9. Click on Got it to close Publishing to Power BI popup

10. Close Power BI Desktop.

---

Reference

Power Automate Reference

1. Power Automate Desktop