cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinter Frequent Visitor
Frequent Visitor

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 Power BI allows me to show error messages in English, so you are going to have to live with my translations together with Power BI's beautiful mixture of languages.

 

I have a report created in Power BI Desktop on a computer where the Personal Gateway is also installed. Data refresh works fine in the report, so I upload it to the cloud.

 

Capture1.JPG

 

I am told, the credentials are wrong

 

Capture2.JPG

 

So I go and edit them, but now I am told, the correct data provider is missing

 

Capture3.JPG

I go to the link

 

Capture4.JPG

 

However, installing the file there does not solve the problem and I get the exact same error.

 

I search for "64-bit (x64) 'MySQL Connector/Net" and find there is a newer version than the one in the link. However, it is only 32 bit:

 

Capture5.JPG

 

Installing that does not mend the problem and then I am lost. Can you think of anything to try?

 

Thanks in advance!

 

 

 

5 REPLIES 5
KevinEpiSound Frequent Visitor
Frequent Visitor

Re: Connecting to MySQL via Personal Gateway

Hey Vinter!

 

We are running into the same problem, we have installed the connector but are still facing the same problem. I will today look for workarounds/solutions, and will get back later today or tomorrow.

 

// Kevin @ EpidemicSound

vinter Frequent Visitor
Frequent Visitor

Re: Connecting to MySQL via Personal Gateway

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

Highlighted
KevinEpiSound Frequent Visitor
Frequent Visitor

Re: Connecting to MySQL via Personal Gateway

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 Smiley Happy

konstantinos Senior Member
Senior Member

Re: Connecting to MySQL via Personal Gateway

@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..

 

 

 

 

Konstantinos Ioannou
vinter Frequent Visitor
Frequent Visitor

Re: Connecting to MySQL via Personal Gateway


@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".

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 124 members 1,419 guests
Please welcome our newest community members: