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
Mgodby
New Member

When doing an "export data" the excel file when opened refreshes the query, how to stop this?

I am on app.powerbi.com and when I do "export data" and then "summarized data", it creates an excel file.

Mgodby_0-1683581807630.png

Mgodby_1-1683582378505.png

The issue is that once we have completed working on this extract file and close it, and then open it again it connects back to the server and refreshes the query. The data we used for creating the extract file updates and then replaces it with the new data. Is there a way to stop it from refreshing the query? 

Thank you.

2 REPLIES 2
Chloe3
New Member

I don't have a solution to offer sorry, just commenting as I have the same issue and would like to be notified if someone knows how to address it

Did you try going into query editor and disabling "include in report refresh" for the table? Someone told me to try that. I'm very unfamiliar with PowerBI so still learning how to do any of this.

Mgodby_0-1683745735348.png

 

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.