Forum Discussion
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
Hey Anonymous ,
When you go to "Section1/Query1/Expanded Table Column1 " do you see which step it is referring to? And, is that step a data combination of something local or a non-SQL data source? Also, is your gateway up to date and is your Power BI Desktop file up to date? IF they are of sync quite a bit you can get interesting issues similar to this as well.
There is a invoke custom function which is inserting the data in on perime databases
Hey Anonymous ,
In addition to what Anonymous stated, I am wondering, is your function taking a result FROM the query and then inserting data?