Forum Discussion
SharePoint Excel connected to Power BI dataset, with the Excel automatically refresh?
I have created a table in a SharePoint Excel that is connected to a Power BI dataset that is updating nightly. Will the data in the SharePoint Excel also update when the Power BI dataset is refreshed...
Hi hsturm ,
As far as I know, mostly we need to open excel on SharePoint then click refresh to load new data.
According to your statement, I think you want to set schedule refresh to your SharePoint Excel.
Here I suggest you to try Power Automate to run flows on a schedule.
For reference: Run flows on a schedule
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok thank you! Sounds like I'll have to add a portion to the script by opening up and refreshing through the desktop version.