cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mitch2300
Regular Visitor

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

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

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...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
mitch2300
Regular Visitor

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

Best,

Mitch

GilbertQ
Super User II
Super User II

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...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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.

Top Solution Authors
Top Kudoed Authors