Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Close and Apply Without processing in PBI Desktop

Hi All,   Like in SSDT, we have Close and Apply without processing. Is there any way to do same thing in pbi desktop ? Whenever we create something in Edit Query, it expects us to re process the t...
Need Help
akj2784's avatar
akj2784
Post Partisan
8 years ago

Hi Seward12533,

 

Can you please elaborate on this ?

 

Regards,

Akash

Seward12533's avatar
Seward12533
Solution Sage
8 years ago
  1. After query is loaded into your data model
  2. Go to PowerQuery (Edit Queries)
  3. Right Click Query name - add trivial like  a sort, renaming a column you don't actually use or, something else (that does not change or transform your data in any way) as the last step in the transformation
  4. Close and Apply - PowerBi should refresh/update that dataset without needing to refresh all the the other ones.

For example I have many queries some quite large from external  sources and I have a lookup table I maintain to bridge in some dummy customers that arn't yet in our main DB that I append to the master data I pull in from our ODS server. If I want to just updated that table I go into the query editor and either delete or add the sort step at the end. When I close and apply that data soruces that use this lookup table without updating the other ones.