Hi,

I have a query which displays without an issue in the Power Query editor. If I look at the column quality there are zero errors. The query combines Excel files from a SharePoint folder and then merges with another table from the worksheet to add some additional analysis. 

However when I try and return the data to Excel either to a table, a pivot report, or setting it up as connection only and then referencing it as an external data source for a pivot I get the error "Problems obtaining data".

Any ideas what might be causing this or what else I could try to resolve it?

Thanks

Bax