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 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.

 

 

1 Reply

  • collinq's avatar
    collinq
    Super 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!