cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UsePowerBI
Post Prodigy
Post Prodigy

Does connection refreshing schedule work in xlsx on sharepoint?

Hello

 

If I build a desktop xlsx with Queries and Connections to a SQL server and set this connection to refresh every 30min, will this work in the Sharepoint/Online version of this xlsx after I upload it to Sharepoint?

 

Thanks!

3 REPLIES 3
UsePowerBI
Post Prodigy
Post Prodigy

@mussaenda  thanks but I don't think my question was clear

 

Let's say you have an xlsx with some data connections which you have set them to refresh every 30 min. The xlsx can be stored in your Sharepoint, OneDrive or local directory.

 

Will the data refresh in this xlsx when the file is not open? Can we make it to?

Hi @UsePowerBI ,

 

I believe yes. Have you tried to test it?

mussaenda
Resident Rockstar
Resident Rockstar

Hi @UsePowerBI ,

 

If you are using a sharepoint connector, it updates everytime you update also your online file.

Hope this helps.

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors