cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abpgupta
Helper IV
Helper IV

Power Automate to refresh dataset on One drive

Hi

 

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!

1 REPLY 1
lbendlin
Super User III
Super User III

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

lbendlin_0-1612051854787.png

 

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

Announcements
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!

secondImage

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.