Pending Changes Banner Appears After Every Field Properties Update

[Anonymous]

I have a dataset in PBI Desktop that consists of about 35 tables of varying sizes. The storage mode of these tables are either Direct Query or Import depending on a table's size and frequency of the underlying data being updated. 

I am in the process of updating the descriptions of all fields within these tables. However, every time I update a field I receive the following banner notification:

"There are pending changes in your queries that haven't been applied"

If I ignore the notification or simply move to the next field to update it's description, the previous field with an updated description reverts back to it's original state. If I Apply changes, the entire table is evaluated and has to connect to the data model every time which can take 30+ seconds every time a field description is updated. This scenario occurs whether the table is import or Direct Query

Is this normal Power BI functionality when updating field properties? If so, is there a workaround and is this on Microsoft's PBI pipeline to address? If this is normal, this seems really inefficient for simply adding a description to a field

[amitchandak]

@Anonymous , please see if these setting can help : https://www.thebiccountant.com/speedperformance-aspects/

[Anonymous]

@amitchandak -

I disabled "Background Data - Allow data preview to download in the background" and "Relationships - Autodetect new relationships after the data is loaded" as those were the only 2 options in the article you shared that possibly related to this issue. Unfortunately, neither of these solutions helped with this issue.

I'm still not sure why I'm required to Apply Changes after every insertion of a field description. Is there an easier way to do this in Transform Data? 

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

I have a test by mixed connection mode (Import and Direct Query) .

It seems that we need to apply changes before we change another description.

You may need a Delay Model Update function in changing description.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：

Add the ability to Delay Model Update while making data type, format and property changes; incorporating an Apply button could work.

Or you can submit a new idea to improve the Power BI.
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,

Rico Zhou

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