Reply
v5out
New Member

Power BI Desktop error when connecting to local MySQL

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

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
RADFS_FinCon
New Member

Untitled.jpg

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
Super User
Super User

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Thanks smoupre, you were exactly right!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)