Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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 ?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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