cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dodiyal
Regular Visitor

HOW TO SAVE POWER QUERY WITHOUT REFRESHING DATA AFTER THE DATA SOURCE IS CHANGED

hello team,

Kindly note i work with a huge dataset from server alomst 1 GB. I do have the same folder in my local pc but i keep only less number of same files so that whenever i do amendments i can refresh the data and check it and then save it so that i do not need to directly use data from server which takes lot of time to refresh.

I have seen that whenever i change the data source it is not possible to save the data without REFERESH the data, i need to APPLY QUERY. 

Is there any method while i change to data source then Power query do not refresh and only take the differnt data source and save it?

 

Example

1) Here is the PBI desktop data source connected to my local folder

 

dodiyal_1-1610303828929.png

2) When i change the data source to server 

dodiyal_2-1610303964590.png

while savin it refreshes 1 gb data from server 

dodiyal_3-1610304014560.png

If i click APPLY LATER then DATA SOURCE is not being changed

 

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @dodiyal,

Nope, I don't think you can achieve this.  The backend query table only shows the preview of m query processing result, these records not really change the current data models table records.
You need to do apply the change to re-generate the new model table records based on the latest codes. 
Notice: m query code has been updated, but these changes not auto applies to the data model to prevent the data structure change which may break the front report design and calculation expressions.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
parry2k
Super User
Super User

@dodiyal yes anytime metadata is changed, it will refresh the data. 

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors