topic Re: Getting a data Mashup error in a union query between an azure table and a SQL Table in Report Server

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

bwhitlocksaxco — Thu, 23 Aug 2018 20:18:29 GMT

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.

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

BhaveshPatel — Fri, 24 Aug 2018 06:39:26 GMT

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

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

bwhitlocksaxco — Fri, 24 Aug 2018 14:52:49 GMT

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?