Forum Discussion
Getting a data Mashup error in a union query between an azure table and a SQL Table
I have two tables that Im querying. One table in Azure the other in a local SQL Table. Im doing a Union Append on the two tables which works fine on the desktop version of Power BI.
When I load it to the cloud I get a data Mashup error. the gateway is properly set because if I remove the Union I dont get the data mashup error in my dataset setting of my on premise gateway.
Any ideas? my fields match exactly in both alignment and field type.
2 Replies
As you are trying to combine the two different data sources, this may occur.
Have you adjusted the privacy level settings in the PQ Editor.
Check out the documentation:
https://docs.microsoft.com/en-us/power-bi/desktop-privacy-levels
Thanks
Bhavesh
Thanks for the reply. My settings were set to Ignore. I also went through each db and set the privacy level permissions to none so they were all the same. I cant even join an excel spreadsheet to the azure db. I keep getting this error
Also does it matter that one table is using organizational credentials the other windows credentials?
