cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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 connection in Manage Gateways, the connection is Successful as well.

 

But, when trying to connect via dataflow, it keeps throwing an error Invalid Credentails. 

 

We checked with Firewall team, and there is no restrictions.

 

Could you please help. 

 

Thanks in advance.

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: PowerBI Dataflow - invalid Credentials

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.

Support Ticket.gif

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Helper I
Helper I

Re: PowerBI Dataflow - invalid Credentials

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

Highlighted
Advocate II
Advocate II

Re: PowerBI Dataflow - invalid Credentials

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?

Highlighted
Regular Visitor

Re: PowerBI Dataflow - invalid Credentials

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors