Forum Discussion
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...
I have encountered a similar problem in experiencing the "Invalid Credentials" error when trying to create a dataflow query that used our PBI Gateway to access a MySQL DB. After some experimentation, I found that the solution was to go into the "Advanced settings" of the data source within the gateway configuration and set the "Connection Encryption setting for this data source" setting to "Encrypted". By default, a checkbox was set that allowed the gateway to choose the connection encryption setting - this needed to be overridden.
Once the gateway setting was changed (and basic username/password credentials re-entered) I was able to successfully create/execute the dataflow query.
Hope this helps
Cheers,
Jeff