Power BI Desktop error when connecting to local MySQL

[v5out]

I have a local MySQL server running and can connect to it and view data with Workbench.

1. Start Power BI Desktop - Get Data - MySQL Database - Connect

2. In "MySQL Database" dialog enter "localhost" or name of local machine, tried both ways. Enter name of database. Hit Okay.

3. Get "Query1 - Query Editor" dialog which says "DataSource.Error: Object reference not set to an instance of an object."

What am I doing wrong?

Thanks!

John

[RADFS_FinCon]

Good Day, All.

I have adopted the advised solution - realignment to "Database Credential, from Windows Credential" - this had solved the initial problem, as per the other users.

However, due to my lack of experience in Power BI, I have unearthed another "gremlin" - see the above picture.

There is reference to:"The name provided is not a properly formed account name"

Can someone help me, please...???! 

Thanks in advance

Regards

RADFS_FinCon

[Greg_Deckler · Accepted solution]

You are most likely getting a "user not authorized error". Go to File | Options and Settings | Data source settings and edit your data source. I have gotten MySQL to work but I used Database credentials, not Windows credentials. I built this using MySQL database:

https://www.linkedin.com/pulse/amend-purpose-bill-text-analytics-us-congress-greg-deckler?trk=pulse_...

I *think* I included some specifics about the connections and such in that article.

[v5out]

Thanks smoupre, you were exactly right!