updaing a table in Power BI failed to pick up changes made afterwards

[Bin_Zhao]

Hi, I need help with desktop Power BI.

As you can see, the above image shows the same table imported today and a few weeks ago respectively. The table imported a few weeks ago failed to pick up the added fields or renamed fields after refresh. The table imported today can pick up all the changes. I cannot afford to import tables everytime after making changes to the table.  The table is in Dataverse for Team.

how to make sure the table reflects the changes after imported to the Power BI desktop?

Regards

Bin Zhao 

[Anonymous · Accepted solution]

Hi @Bin_Zhao,

AFAIK, power query tables will cache the table structure into the quest steps and does not auto sync even if the remote data source structure changes.

For this scenario, you need to manually check these query steps and manually modify these not match part to help query table successes processed or they will return the key field not match errors.

Regards,
Xiaoxin Sheng