data mashup error
2 TopicsDM_GWPipeline_Gateway_MashupDataAccessError
Hello Experts, could you please help me with this error, I am trying to do refresh on my published report but having this error not sure what and why this is happening I have multiple MySql and MariaDB connection for Data Source when publishing PBI asked me to configure on-premises Datagatway for every Data Source which I did for all and then tried to refresh the Semantic model and had this error Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The given credential contains a property with a null value. Data source kind: Web. Property name: Username. "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: FC. Thank you for you time and effortsSolved2.2KViews0likes5CommentsGetting 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.1.3KViews0likes2Comments