Forum Discussion
v5out
11 years agoNew 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 "lo...
- 11 years ago
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.
Greg_Deckler
11 years agoCommunity Champion
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.
- v5out11 years agoNew Member
Thanks smoupre, you were exactly right!