Refresh Error unable to combine

[steigelbill]

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 following message.  If I didnt change anything in my query, report or dataset why would I all of a sudden get this? Is it possible it's a PBI Service issue?

[Unable to combine data] Section1/Func_d7c9329b_cd64_4ccb_8f12_68166ec6797a references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface.

[collinq]

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!