Forum Discussion

Darwin_gaming's avatar
Darwin_gaming
Frequent Visitor
3 years ago

Gateway can not be select

Heey guys, 

I need to access my MySQL database using Dataflow from Power BI Service. When I try to enter the server and the database's name, my gateway is not appearing.

I'm using the on-premises personal mode for the gateway, and all the gateway parameters are correct. The gateway shows an online status.

The credentials are displayed as shown in the picture, and I am unable to do anything

Did anyone know how to fix it?

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
    and all the gateway parameters are correct

    I will challenge you on that.  if they were then the gateway would be selectable.

     

    connection details have to match EXACTLY, including the spelling. This stuff is case sensitive.

     

    Side note:  you may want to downgrade to 8.0.28 for the MySQL driver.  Newer drivers have caused gateway issues.

  • Darwin_gaming's avatar
    Darwin_gaming
    Frequent Visitor
    3 years ago

    I tried this too, but didn´t work it. 

    By the way I installed other gateway and worked. 

    Thanks for you suggest. 😁