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 .
Need Help
RichardJ's avatar
RichardJ
Responsive Resident
6 years ago

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
    6 years ago

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

     

     

    • FarhanAhmed's avatar
      FarhanAhmed
      Community Champion
      6 years ago

      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.....

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        It is fine when I "Refresh Preview" in power query, I receive the error when I close and apply. 

         

        Any suggestion FarhanAhmed