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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors