Forum Discussion

Frequent Visitor

10 years ago

Connecting to MySQL via Personal Gateway

Hi I am getting an error when connecting a report to a MySQL database through the Personal Gateway. My problem is similar to this, but the solution there is no solution here. I don't see how Powe...

Frequent Visitor

10 years ago

Great, I would love to hear that! Also good to hear it is not me being completely wacko.

Regular Visitor

10 years ago

Hi again,

what I did yesterday was that instead of publishing from PBI Desktop, I uploaded the .pbix file from PBI Online.

"Get data"-tab, under files, and select your .pbix file, after that schedule refresh worked fine!

Try that :)

konstantinos
Memorable Member
10 years ago
KevinEpiSound vinter I have the same problem & exact error message..Get data don't help..if you have any other suggestions.

Maybe my case is a bit different. The personal gateway is installed on Azure VM ( always on ) and I try to upload the PBIX from my laptop. MySQL domain is different than in Laptop or VM. When I refresh pbix from my laptop is working great ( at the beginning I have the same issue but I downloaded the latest net provider as also MySQL workbench & utilities )..

Hope there is a solution or workaround...First time I connect to MySQL so no experience..
vinter
Frequent Visitor
10 years ago
KevinEpiSound wrote:
what I did yesterday was that instead of publishing from PBI Desktop, I uploaded the .pbix file from PBI Online.
"Get data"-tab, under files, and select your .pbix file, after that schedule refresh worked fine!

Great idea, but unforturnately, it does not help. I get the same error:
Little triangle - "credentials are wrong" - "Must install data provider".