Forum Discussion

joost786_12's avatar
joost786_12
Regular Visitor
2 years ago

On Premise Gateway

Hi I am getting the following error when using my on premise gateway for a sql server. I've tried changing privacy settings didn't work. I use basic authentication currently with the details of my sql server, anyone has a fix for this problem?

 

{"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: MySql. Property name: Username. "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: outsmart_19019 worksheet_materials.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi joost786_12 ,

    First of all , the error statement is "The given credential contains a property with a null value , indicating that your database credentials are null , and here you can check the database credentials , and then you can also use the OAuth 2.0 link.

    Best Regards,

    Xianda Tang

    If this post helps , then please consider Accept it as the solution to help the other members find it more quickly.