Get specific data columns from Dynamics 365 CE with Odata query Rest Api

[Anonymous]

Hello,

I have an issue that i was retrieving specific columns from Dynamics 365 customer engagement using Rest Api odata query and every thing was alright, But suddenly after few days the query cannot retrieve any object/refrence/lookup column, it only retrieves simple data type columns, and it gives an error of (Expression Error : The column "column name" of the table was not found).

Please any help ?

[Anonymous]

Hi @Anonymous,

This issue operation appears when your data structure change that new record does not match the change table schema.(power query will cache the table structure into the query steps and not auto sync)
Any data structure changes on your data source side? Please share more detailed information to help us clarify your scenario.

How to Get Your Question Answered Quickly 
Regards,
Xiaoxin Sheng