Apply query changes error

[Anonymous]

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 .

[RichardJ]

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]

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

[FarhanAhmed]

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]

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

Any suggestion @FarhanAhmed 

[FarhanAhmed]

I am not sure if I have something for you now

but you can go thru below

https://community.powerbi.com/t5/Power-Query/Unable-to-read-data-from-the-transport-connection/td-p/...

https://community.powerbi.com/t5/Community-Blog/CRM-Online-issues-with-oData-and-solution-with-Fetch...

Although I suggest you to create a new power bi file and try to import tables one by one there and see which table causing you problem.

I suspect one of your table is locked or timeout getting you this error.