Forum Discussion

steigelbill's avatar
steigelbill
Frequent Visitor
5 years ago

Refresh Error unable to combine

Hi all,  I created a querey that combines multiple excel files hosted in sharepoint.  The report has been on scheduled refresh without a problem since July.  Then today it errors out with the followi...
collinq's avatar
collinq
Icon for Super User rankSuper User
5 years ago

HI steigelbill ,

 

You may have a parameter issue.  If you go back to edit your queries and find the parameter select "Any Value" from the drop down for the "query" or "list of values" option.

 

OR, a data source may have been moved from its location?  One file that is not there anymore?  OR, the data source was temporarily unavailable?

 

OR, it could that you are combining an external data source within the query and you ahve to remove the external data source (https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/).

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!