Reply
Member
Posts: 242
Registered: ‎09-08-2017

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 table which is pain everytime if it is a big table.

 

Is microsoft thinking in that direction to make it in sync with SSDT process ?

 

Regards,

Akash

New Contributor
Posts: 444
Registered: ‎02-15-2018

Re: Close and Apply Without processing in PBI Desktop

You can selectively temporarily turn off refresh for specific tables by right clicking query name and unselect “include in report refresh”
Member
Posts: 242
Registered: ‎09-08-2017

Re: Close and Apply Without processing in PBI Desktop

but when I publish it to AAS, again I will have to enable it right. And in that case again it will expect me to process the table.

 

So you mean during developement phase, I need to disable this. Once it is done we have to enable it again and publish it to cloud.

 

 

New Contributor
Posts: 444
Registered: ‎02-15-2018

Re: Close and Apply Without processing in PBI Desktop

Right. If publishing to BI device you can do incremental refresh. Not sure if you can do in azure. But I’d assume so.
https://powerbi.microsoft.com/en-us/blog/tag/incremental-refresh/
Highlighted
New Contributor
Posts: 444
Registered: ‎02-15-2018

Re: Close and Apply Without processing in PBI Desktop

Another trick in development mode is to go into query editor and so trivial edit to the one data source you want to update. (Add or remove sort) then close and apply and it will only updated that one table/source (well all tables that use that source)
Member
Posts: 242
Registered: ‎09-08-2017

Re: Close and Apply Without processing in PBI Desktop

Hi @Seward12533,

 

Can you please elaborate on this ?

 

Regards,

Akash

New Contributor
Posts: 444
Registered: ‎02-15-2018

Re: Close and Apply Without processing in PBI Desktop

  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.

 

Untitled5.jpg

Community Support Team
Posts: 6,249
Registered: ‎05-02-2017

Re: Close and Apply Without processing in PBI Desktop

Hi @akj2784,

 

The Query Editor is a tool to shape data. The dataset is the source that we will use to analyze. If we don't apply the changes, why should we do that? 

 

Surely, we can close it without applying the changes. 

Close_and_Apply_Without_processing_in_PBI_Desktop

 

 

 

Best Regards,

Dale

Member
Posts: 242
Registered: ‎09-08-2017

Re: Close and Apply Without processing in PBI Desktop

Hi Dale,

 

I understand your point, but there can be a situation where you have to add/modify something in the edit query but dont want to process it as it takes a lot of time. Instead you want to process the entire model once all the changes are completed.

 

Specially considering the fact that if we deploy the model on AAS, why would someone like to process it in local?

Processing on local would be slower as compared to AAS.

 

Regards,

Akash

Community Support Team
Posts: 6,249
Registered: ‎05-02-2017

Re: Close and Apply Without processing in PBI Desktop

Hi Akash,

 

I would suggest you create an idea here. The big models would consume many resources. That means the bill will be large if we do it in the AAS.

 

 

Best Regards,

Dale