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.
