Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

shisukon0210

Some problem make power BI can't access mysql, need some help.

Submitted by on ‎06-26-2023 10:59 PM

shisukon0210_0-1687844896575.png

I get some problem when I get resource by ODBC in Power BI. The thing pretty weird is that my user name is not 'user', but the issue say that the access denied for username 'user'.

shisukon0210_1-1687845209479.png

 

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎06-27-2023 11:04 PM

Hi @shisukon0210 

If you use the account "root" to sign in data source , you can access the data in MySQL ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

shisukon0210
New Member
‎06-27-2023 11:44 PM

@Anonymous 
No,
I created database by HeidiSQL, and it can be MySQL or MariaDB. Then, I tried to access data source by MySQL or MariaDB at first but it not work. The picture in my first post is that I try to access data source by ODBC which is work in other case.

I also installed the plugin below.

shisukon0210_0-1687934605093.png

 

Idea Statuses