Forum Discussion
Power Query Data Gateway
I am getting this error while refreshing through gateway where as it working properly in desktop version
Underlying error code: -2147467259
Underlying error message: [Unable to combine data] Section1/Query1/Expanded Table Column1 references other
queries or steps, so it may not directly access a data source. Please rebuild this data combination.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"SQLSODWQA01\\SQLDevelopment;Stage_DataWarehouseWMS"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacyError
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: abb11f07-e321-5801-6299-8f175b4ac3f2
Request ID: 205d39fb-964c-1f11-90d7-6f4bdb5fba15
Time: 2023-01-06 15:36:51Z
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.
-
4 Replies
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.
Hey Anonymous ,
In addition to what Anonymous stated, I am wondering, is your function taking a result FROM the query and then inserting data?
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.
-
