Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |