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.
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.
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
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.
Thanks smoupre, you were exactly right!
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!