Expression.Error: The column '' of the table wasn't found.

[bobbity]

Hi, I have an excel workbook with 5 queries, 3 of which were dynamic exports from Dynamics 365 CRM and the other 2 which were appended queries. While my workbook works fine with refreshes, another office which uses the same workbook gets the error "Expression.Error: The column '' of the table wasn't found." whenever they refresh their workbook. I asked them to send over the file, and when I went into power query editor to check the "Source" step of the queries with the error, it just showed this. 

Any advice on this will be greatly appreciated. Thank you.

[PC2790]

Hey @bobbity ,

Have you tried refreshing the workbook once?

See if doing this helps.

[bobbity]

Hi @PC2790 ,

When I first got their workbook, refreshing gave me the same error. But after a/couple of refreshes on my computer, it worked fine. If I sent them back the file I just refreshed, they will still get the error on their end. 

[PC2790]

Have they tried the performing the workaround in my previous step?

And I hope they have the required access?

[bobbity]

I am not sure how to reset/clear IE settings/cache as there is no option to do so inside Excel Web Query. They do not have IE installed also, only Microsoft Edge. 

They do have the appropriate permissions to access the data.