| title | Auto refresh and publish report to default workspace using Power Automate Desktop | |||
|---|---|---|---|---|
| author | Johnney Cao | |||
| date updated | 2023-04-24 | |||
| keyword |
|
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.
- FileFolder: Required, Data Type as
text - FileName: Required, Data Type as
text
-
AppProcessId, used in UI elements,
Elements.Ordinal = %AppProcessId%
-
FullName, Combine FileFolder and FileName above
-
Set variable FullName;
FullName = %FileFolder%%FileName%.PBIX
-
Run the Power BI report above in default application
-
Wait for the report is open and Refresh button is ready, and then click on Refresh button to refresh data;
-
Wait Refresh popup is closed, and then click on Save button to save the changes;
-
Wait Publish button is ready, and then click on Publish button to start publishing report;
-
Wait Publish to Power BI form is popup, and click on Select button to use the default workspace;
-
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;
-
Wait Publishing to Power BI form is popup, and then click on the Report URI to open report from Power BI Service;
- Change the attribue below in UI Element which ends with
PBIX" in Power BI
- Change the attribue below in UI Element which ends with
-
Click on Got it to close Publishing to Power BI popup
-
Close Power BI Desktop.
