HELP! Dataset (MySQL) refresh error

[Anonymous]

Hello, everyone! I hope everbody is safe at home!

I really need some help with this error that I get trying do refresh this dataset on PBI Service.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Unable to connect to any of the specified MySQL hosts."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"appzinho-producao.cbppgyuuackj.sa-east-1.rds.amazonaws.com;appzinho"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Unable to connect to any of the specified MySQL hosts."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Dim_Filter.

I can figure out, own my own, the obvius: There's something wrong with this particulary table, but i just can't undersant what. I've redone it from scratch, in hopes of getting rid of the error, but it worked just for a couple of hours before I went to sleep and today the error is back again and its spreading to the other datasets of my project. Im going insane here!

Please, help me!

Many thanks,

[mariamoreno]

Hello, i have moreless the same issue (HELP!)

Could you please provide the following information in order to make troubleshooting?

1. Whether you can connect to local MySQL successfully?

Yes i can

2. Whether it is successful when refresh in Power BI Desktop?

Yes, every report

3. Which type of gateway installed in your machine? Personal gateway or enterprise gateway?

Standard Gateway

4. The screen shot of configurating gateway in Power BI Service

This is the error message, the gateway is online but can´t enter to the db

No se pueden actualizar las credenciales de conexión. No se puede conectar al origen de datos. El origen de datos es inaccesible, se ha agotado el tiempo de espera de la conexión o las credenciales del origen de datos no son válidas. Compruebe la configuración del origen de datos y póngase en contacto con un administrador del origen de datos para solucionar esta incidencia.

Detalles:ZZZZZZ: MySQL: Unable to connect to any of the specified MySQL hosts.

[GilbertQ]

Hi @mariamoreno 

Can you make sure that the Gateway can connect to the DB?

[Anonymous]

Hi @Anonymous ，

Could you please provide the following information in order to make troubleshooting?

1. Whether you can connect to local MySQL successfully?

2. Whether it is successful when refresh in Power BI Desktop?

3. Which type of gateway installed in your machine? Personal gateway or enterprise gateway?

4. The screen shot of configurating gateway in Power BI Service

In addition, you can review the following documentations, hope they can help you resolve the problem.

MySQL and Power BI, How Does It Work?

Unable to connect MYSQL issue

Best Regards

Rena

[Anonymous]

Hi, @Anonymous , thanks for the reply!

1. Whether you can connect to local MySQL successfully? A:Yes, I can and through PBI Services with another datasets from the same MySQL Server.

2. Whether it is successful when refresh in Power BI Desktop? A: Yes, it is!

3. Which type of gateway installed in your machine? Personal gateway or enterprise gateway? A: Enterprise gateway (standard)

4. The screen shot of configurating gateway in Power BI Service

The screen shot is in PT-Br, hope you don't mind. 😃

Gonna check the links you gave me! many thanks!

[Anonymous]

Hi @Anonymous ,

Thanks for providing these information. It seems OK. Whether it can be refreshed manually in Power BI Service? If the gateway be installed in a stable environment with good network and continuously connected machine?

Best Regards

Rena

[Anonymous]

Hello @Anonymous ,

Sorry for the delay on replaying to you. Since I couldn't figure out the reason this was happening, I've rebuilt that specific table on my dataset from scratch and the problem vanished.

Now I had to setup a virtual machine to keep the data refreshing automaticly and the problem reappeared. Before I use to have the gateway installed on my own machine. Both the virtual machine and mine are in a stable environment with good network. My machine wasn't always online, and that's why I've got the VM running. But the error didn't occur in my machine after I've done the table rebuilt. Even when the gateway was offline, because my pc was off, once I got it up running again, the refresh worked like a charm. Both scheduled and on demand refresh.

I dont know what to do.

The file works fine in PBI Desktop. It had one good automatic refresh and since then just errors. 

Do you have any idea what can it be? I dont want to waste another few days of work rebuilding another table from scratch again.

[GilbertQ]

Hi there

It appears that the error is with the HOSTS file and it cannot find the underlying host?