- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks smoupre, you were exactly right!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-09-2024 10:45 AM | |||
10-02-2022 07:57 PM | |||
Anonymous
| 07-30-2024 12:31 AM | ||
09-13-2024 12:55 AM | |||
07-24-2024 02:26 AM |
User | Count |
---|---|
55 | |
54 | |
49 | |
13 | |
13 |