power bi service dataset refresh error with Mysql

[ehuila]

I have a dashboard in power bi service that I publish from desktop power bi where
it works fine but in the service it doesn't update the dataset it takes like 30 minutes
then it throws an error message but the gateway is configured correctly .

This is the error:

[aj1973]

Hi @ehuila 

What is the message saying? are you using an on premise Gateway? what is the source?

[ehuila]

Hi.

If I am using a local gateway and when I configure the gateway it connects correctly.
The data source is MySql. The problem arises when I update the report in power
bi service and the following message appears

Thanks for all the help you can give me.

[aj1973]

But you are not helping understand the message , I don't understand Spanish sorry.

[ehuila]

This is the error:

An error has occured

Please try again later or contact support. Please provide these details if you contact them

cluster uri: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
activity identifier: e5b925b5-5696-4a40-955a-38439356ce76
Request identifier: 8d853539-977b-45f8-aed3-0294c02b4669
Hour 2022-01-23 04:45:28Z

Thanks

[aj1973]

Are you able to show me this page

[ehuila]

update history message

Thanks

[aj1973]

Can you click on show details please

It looks like the refresh process is timing out, 45+ mins to refresh that means the dataset is big or not optimized....Was the refresh process working before? How big is your dataset? in your desktop how long it takes for the report to refresh?

[ehuila]

attached image.    If I update in power bi desktop it updates without problem

[aj1973]

Like I mentioned earlier, the Gateway and credentials are all well setup but the refresh is Timing out, It happens when there is shortage memory in Power bi that would need adjustments (like moving to Premium Capacity) or you have to Optimize the performance of your report.

Let's try something: delete a visual (heavy one) or a page if you have multiple pages from your report and publish it to the same workspace but with different name. Refresh it and tell me how it goes!

[ehuila]

Hi.

I already did it with only one page and only one visual object and only
linking a MySql table. Also the same error comes out.

Thanks for all the support.

[aj1973]

I see,

You probably are going to need an ODBC driver to solve your problem

Solved: Connection to MYSQL, personal gateway - Microsoft Power BI Community

[ehuila]

Hi Amine.

I followed your odbc recommendation, but when creating the
connection in the gateway I get an error, what should I put in the connection string?

[aj1973]

Hey @ehuila 

I found this 

Solved: On-Premesis Gateway cannot connect to MySQl source - Microsoft Power BI Community

Try it before exploring ODBC, it might work for you.

[aj1973]

No , not there that's the Gateway configuration and your Data source type is MySQL is it not?...

At the report level from the desktop, you need to change the connection string and use ODBC driver then republish it and try with the same Gateway that is already installed on Premises. 

Make a test with one table , one visual and publish it. Let me know