Forum Discussion

vikkidurai91's avatar
vikkidurai91
Helper I
6 years ago

PowerBI Dataflow - invalid Credentials

Dear   We are trying to pull data from AWS MySQL to PowerBI Dataflow.    With the details of Server, DB, username and password, we are able to connect to DB via Desktop Tool. When added the conne...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi vikkidurai91 ,

 

Could you please make sure that you have configured gateway for your database and you could check if the credential is correct in your gateway and be same withe the credentials in your dataflow?

If the issue still exists, you could create a support ticket here.

 

vikkidurai91's avatar
vikkidurai91
Helper I
6 years ago

Hello

 

Thanks for your response.

 

Yes we have configured the gateway and using it for a while. Connection is successful, when I added MySQL details in Gateway as well.

 

I was able to make connection via Desktop tool but not from Dataflow. It keeps saying Invalid Credentials.

 

Thanks

Vignesh

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey vikkidurai91 

     

    My organization is having the same problem.  

     

    We can create a Power BI report that uses a MySQL database connection, and we can publish that report on the Power BI service and and it will successfully refresh via the on-premise Data Gateway.

     

    However, when we try to create a Dataflow, we keep encountering an error during the  "Connect to data source" step, where it complains about Invalid credentials.  Obviously, something isn't working quite right yet. 

     

    I suppose we will have to reach out to Microsoft Support directly.   Were they able to resolve your issue?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      We're experiencing similare issues for a PostgreSQL database hosted on AWS.

      PBI desktop on our gateway server can connect without issues to the DB.

      But once we try to create a dataflow we also get the invalid credentials error which is ridiculous as the datasource was created without an issue...

       

      KR,

      Thomas

      • david_moody's avatar
        david_moody
        New Member
        6 years ago

        II am having the same issue. Was this ever resolved?