Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Apply query changes error

I am having challenges applying changes to query.

My data source is D365 and I am using Fetchxml . Please see attached pictures 

 

Any help would be appreciated .

5 Replies

  • RichardJ's avatar
    RichardJ
    Responsive Resident

    Hi Anonymous ,

    Not sure how helpful this is but I had similar error messages when using an Access Database as the source.

     

    Only started having problems recently for some reason.

     

    The workaround for me was to clear the PowerBI caches,  open the source Access Databases locally on the same machine that Power BI Desktop was working on during the refresh and then refresh worked ok without any ODBC errors. 

    Cheers,

    Richard

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      thanks RichardJ I have tried what you suggested but I am still having same error message. 

       

       

      • FarhanAhmed's avatar
        FarhanAhmed
        Community Champion

        When you are clicking "Refresh Preview" in Power Query, does it refreshing fine or you are receiving error there  too ?

         

        I am not sure if this is something to do with whitelistip.....