Could not resolve query definition. This error often happens after the Column or Entity was renamed

[ROOKIE123]

大家好

  我在 Power BI 服務中遇到了問題。在 Power BI Desktop 中更改某些列名稱後，我發現在重新發佈到工作區時無法刷新數據集。但是，如果我更改名稱然後上傳它，刷新就會起作用。此外，在不同的工作區中刷新也可以正常工作。

我該如何解決這個問題？

[Anonymous]

Hi @ROOKIE123 ,

Please note that next time please post in English, thank you!

Best Regards
Dino Tao

[Anonymous]

Hi @ROOKIE123 ,

This error message is usually encountered when a column or entity has been renamed or deleted, and the query definition can no longer be resolved. One possible solution is to check if the renamed entity is used in any other step on the Power Query or PBI DAX side. If so, you need to change its name there as well. This should fix the issue.
If you encounter this error directly in the Power Query, you can go into the query and see at which step the error occurs one by one. The query probably breaks in one of the query steps.
If the above solutions do not work, you can try clearing the data source cache in Power BI. In Power BI client, go to Data Source Settings and clear all permissions. Then recapture the permission again.

Best Regards,

Dino Tao

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

[MC-44]

Thank you, it solved my issue

[OguzMavice]

Hi @ROOKIE123 , Do you use the entity which is renamed on any other step on the power query or pbi dax side? The query path might be broken.

[ROOKIE123]

Thank you very much for your response.

Yes, I renamed a column name. What should I do next to modify it so that it can refresh normally?

[OguzMavice]

Wherever else you use the renamed entity, you need to change its name there as well. Then it should be fixed.

If you get this error directly in the power query; could you go into the query and see at which step the error occurs one by one? The query probably breaks in one of the query steps.