cancel
Showing results for 
Search instead for 
Did you mean: 
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.


@ 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!:
Mastering Power BI 2nd Edition

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.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks smoupre, you were exactly right!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors