Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Power Queries and external connections

I am working on 12 monthly files and linking them to another external file that will compile them YTD.

 

The 12 monthly files have quite a number of worksheets (25 offices/worksheets for each month). I've created a Power Query to combine all of the 25 tabs to generate a report that will give me a monthly view.

 

Next I take the data that is generated by the monthly Power Queries and have connected them (Existing Connections/Browse.../connections in this workbook).

 

Everything was working perfectly during my creation of these files. Now, down the road, I am having my users input their data. When I open the YTD file, the data is not automatically refreshed. I have tried what I know to update settings to select automatically refresh upon open, but that is not working.

 

Any help would be welcomed and appreciated.

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

In the absence of any details about what you've tried to make this work, the best I can do is offer you a link to the MS documentation to check that this is what you've tried:

 

MS Support refreshing Excel connections on open and close 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

In the absence of any details about what you've tried to make this work, the best I can do is offer you a link to the MS documentation to check that this is what you've tried:

 

MS Support refreshing Excel connections on open and close 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.