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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors