Forum Discussion
On demand refresh of OneDrive data source
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
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 Made easy with FourMoo and Power BI
2 Replies
Thank you! That is a great idea I had not thought about! Will definitely explore the particulars.
Best,
Mitch
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 Made easy with FourMoo and Power BI
