Forum Discussion

rajendraongole1's avatar
rajendraongole1
Super User
7 years ago
Solved

Dataflow services not able to connect SQL server from add entities

Hi I am trying to connect one of the source entity from power bi services create Dataflow option.   but i am facing error as attached.    can anyone support me on this?       is there...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    7 years ago

    Hi

     

    From Power Bi Desktop , i am able to connect my source system mysql server, the same way i am trying to connect the source system from power bi services dataflow (add entities) to my data source mysql server.

     

    when i am trying to connect i am getting error message as per the first post attached. 

     

    Can you please suggest?

     

    Regards,

    Rajendra 

     

     

     

     

rajendraongole1's avatar
rajendraongole1
Super User
7 years ago

Just checked the data flows again in power bi services., there was an issue at gateway setting, that why I faced this issue. Cleared myself now the data base connections are working fine.

 

able to connect and it works after correcting the gateway settings.

 

Thanks for your support.

alexrobe's avatar
alexrobe
Advocate III
6 years ago

rajendraongole1 : We are in the same boat. I have set up the gateway. I can connect (with the same SQL-credentials), my colleague (also a Workspace Admin and Gateway-Admin) cannot.

Thanks in Advance for clarifying the correct settings.

Alex