Forum Discussion

poiuytrewq7890's avatar
poiuytrewq7890
Regular Visitor
1 year ago
Solved

DM_GWPipeline_Gateway_MashupDataAccessError

Hello community members,

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":"MySQL: Fatal error encountered during data read."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"database-1.celegzr2gruw.ap-south-1.rds.amazonaws.com;AOSISF"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Fatal error encountered during data read."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Query1.

 

I am getting this error after uploading it in Power BI service and then refreshing it. Can anyone help me this error?

  • Please check the following-

     

    • Ensure that you have the correct version of MySQL .NET connector on the gateway machine. 64 bit for 64 bit Power BI and vice versa.
    • Ensure that the connector on gateway is compatible with the version of MySQL running on your database server.
    • Ensure that gateway machine can reach your MySQL server.

    There have been similar threads related to this issue here. Please do a search and see if any of those posts help you. Thanks!

4 Replies

  • pborah's avatar
    pborah
    Solution Sage

    Please check the following-

     

    • Ensure that you have the correct version of MySQL .NET connector on the gateway machine. 64 bit for 64 bit Power BI and vice versa.
    • Ensure that the connector on gateway is compatible with the version of MySQL running on your database server.
    • Ensure that gateway machine can reach your MySQL server.

    There have been similar threads related to this issue here. Please do a search and see if any of those posts help you. Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi poiuytrewq7890 ,
    Thank you for the helpful response pborah  .As pborah suggested, have you got an opportunity to review the information provided.
    Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

    Thank you for being a valued member of the Microsoft Fabric Community Forum!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi poiuytrewq7890 ,

    I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution and Accept it as solution. It would be greatly appreciated by others in the community who may have the same question.

    Thank you for being a valued member of the Microsoft Fabric Community Forum!


  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi poiuytrewq7890 ,
    May I ask if you have gotten this issue resolved?
    If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

    Thank you for being a valued member of the Microsoft Fabric Community Forum!