On demand refresh of OneDrive data source

[mitch2300]

Working on a proof of concept using data files stored on OneDrive for Business. Developing in Desktop and publishing to Service. Using Excel (connected to Service) for reporting. Upon publishing, I don't see a way to mannualy refresh the data from Service?

That's the immdiate issue. Longer term, I need to find a way for my user to refresh the data on demand without logging into the Service (the existence of which should be invisible to the user). Any ideas on this?

Thanks in advance.,
Mitch

[mitch2300]

Thank you!  That is a great idea I had not thought about!  Will definitely explore the particulars. 

Best,

Mitch

[GilbertQ · Accepted solution]

Hi @mitch2300 

What you could do is to use Power Automate to enable the refreshing of the dataset?

Here are more details on how to complete this: Power BI coupled with Power Automate allows for super-fast dataset refreshes - Reporting/Analytics M...