Forum Discussion

fbeuserie's avatar
fbeuserie
Frequent Visitor
9 years ago

EG / is not a valid M connection string / MYSQL connection

 

Hi,

 

I'm unable to manually or schedule a refresh of my dataset.

- enterprise gateway is fine with all datasource created

- powerbi desktop doesn't have any problem with refresh/publish

- datasource type = mysql

 

when i check from the web gui the data source, they are all ok, mysql ones are "connected".

if I set a wrong password, they get failed, so i conclude there is communication between the EGW and the mysql server

 

when I schedule a manual refresh, i get this in the EGW logs:

  

DM.EnterpriseGateway Warning: 0 : 2017-01-17T01:47:18.8801363Z DM.EnterpriseGateway c000d213-e78a-45d0-938a-d94e477f334b 2d7bf9f5-a930-f4c9-cc3e-b50b02bb5804 MGTD 5c33f4a9-cdaf-e577-5b63-e258b7575e13 2BC93840 [DataMovement.PipeLine.MashupCommon] Connection string <pi>DSR="eyJwcm90b2NvbCI6Im15c3FsIiwiYXV0aGVudGljYXRpb24iOm51bGwsImFkZHJlc3MiOnsic2VydmVyIjoiYWx1LXByb2QtcmVwb3J0aW5nIiwiZGF0YWJhc2UiOiJyZXBvcnRpbmd2MiJ9LCJxdWVyeSI6bnVsbH0="</pi> is not a valid M connection string

 

if i decode the base64 string, i get "{"protocol":"mysql","authentication":null,"address":{"server":"alu-prod-reporting","database":"reportingv2"},"query":null}"

 

that's my MYSQL source defined in the PBIX. 

 

i'm probably missing something on the EGW side .... but don't know what.

 

thanks for your informations.

Need Help

3 Replies

  • fbeuserie's avatar
    fbeuserie
    Frequent Visitor
    9 years ago

    i installed both 32 and 64 bits mysql drivers and now it seems to go further.

     

    i've the same error (different base64 string) for all of my datasource.

     

    FYI: aside the mysql one, i've 4 SHP lists datasource.

     

    any idea ?

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi fbeuserie,

     

    From your description, it seems that the dataset connects to the MySQL database and on-premise SharePoint lists, right?

     

    In your scenario, please verify all connection information for the MySQL data source and SharePoint lists are the same as in desktop. When you refresh the dataset, is there any error message throwing out?

     

    Best Regards,
    Qiuyun Yu