Getting a data Mashup error in a union query between an azure table and a SQL Table

[bwhitlocksaxco]

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. 

[BhaveshPatel]

Hi @bwhitlocksaxco

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

[bwhitlocksaxco]

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?