Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Power Automate to refresh dataset on One drive



I have stored PBIX file on One drive for Business. I want to upload this file to Power BI Service to use and auto sync up.


Is it possible to refresh this dataset with Power Automate on One Drive? Do I need to install gateway or it can do it with data sources stored in PBIX file?


Would like to use Power Automate instead of scheduling datasets refresh in PBI Service individually.


Thanks for inputs!

Super User III
Super User III

yes, you can use Power Automate to initiate a dataset refresh on the Power BI service. 



No, you cannot use it to update .pbix files on OneDrive.  (unless you register an app and then do lots of Power BI API call gymnastics in Power Automate - and only for very small .pbix files)


If a gateway is required depends on the data sources in your dataset.

Helpful resources

User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.