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