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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Not applicable

How to avoid refreshing the data in POWER BI query editor whenever I make any change to it?

*** I am not talking about the "Enable Load" option. That option only helps to exclude that query from the actual Data Model.


Question) I am puuling data directly from the CRM using an API Key. I have the data in power BI query editor at this time ready to make any changes. The problem is : If i make any changes to the data (even renamimng the column) the query starts refreshing and downloads the data again by pinging the datasource through the API. I have tried to reference the data and then work with it to make any changes but that does not work either.


Is there a option in POWER BI to overlay a table or to create "connection only"? Please Help

Community Support
Community Support

Hi @Anonymous ,


For your requirement, if are you are very familiar with the Power Query, you can open Query Editor -> Advanced Editor to write Power Query corresponding to the Applied Steps.


There is no such options as you said ,while your demand is a good idea, you can post your new idea here , to improve the Power BI Desktop.


It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.


Best Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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