Power Query Data Gateway

Hi Anonymous ,

There was an error when processing the data in the dataset.
[Unable to combine data]: Table references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

• One reason for this problem is privacy setting which don’t allow multiple sources in single query. Check privacy settings in your report file and every data source used.

  In report file settings you must ignore Privacy settings.

• This problem can be solved by moving your query to Data Flow and using Data Flow as a source in report.

  So create new Data Flow in your workspace and copy your original query there.

  And now for the important part. If you try to refresh your data flow you will end up with another combination error message. You have to change Data Flow Privacy Level as described in picture.

Power BI refresh error: Unable to combine data and workarounds – Meant to BI

Dealing with errors - Power Query | Microsoft Learn

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

If it still does not help, please provide more details with the error.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.