Power Automate to refresh dataset on One drive

[abpgupta]

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!

[lbendlin]

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.