I have recently started to use SharePoint 365 to create Excel files for my organisation in which I am using data sources from other sources to populate via Power Query.
Now the question is rather than manually enter these excel files each week to refresh the data is there a way I can set a refresh schedule? Is it possible to use something like Power BI or Microsoft Flow to set this up as I can't currently see any way of setting any schedule up directly within SharePoint?
I would say it's possible to do this with Flow. This thread describes how to export SharePoint data to Excel.
You can then combine it with this in order to run it on a schedule.
Hi and thanks for your reply.
Not sure however I think the first part refering to the flow of exporting SharePoint list content is relevant if you dont mind me saying? I just need to take the excel document which is saved in SharePoint and refresh the data without actually having to manually enter the document itself?
Sorry about that. I misunderstood what you said.
So just to summarise...
For this, I think it's possible to use some combination of Flow, Excel macros/the 'Refresh data when opening the file' Excel option, PowerShell & on-premises gateway, or some other technique to accomplish this.
I think someone with more experience than me could assist you better - perhaps one of the guys from the BI forum.
Also, @ericonline here has good experience with workflow (not just Flow), and might be able to chip in.
It seems you want to refresh data on a schedule.
You can use flow to achieve that.
And could you please refrence this case?
To be honest I'm not sure I totally follow these posts and what they are achieving? From what I am seeing it refers to publishing your excel file or data source from SharePoint to Power BI if I am correct and then setting a refresh schedule within the data set in Power BI.
However how will this then refresh the data in my excel file located on SharePoint?
Sorry but not an expert in this area!
If you want to solve the issues of PowerBI's schedule setting.
You can post here:
Continue your learning in our online communities.
Next Wednesday, September 18th at 8am PDT
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200