Forum Discussion
Dataflow services not able to connect SQL server from add entities
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
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.
Good to hear it is working now. I have configured the data gateway and the data flow works perfectly now.
Hi rajendraongole1 can you please specify what you did at gateway settings so it now works? thx in advance
I'm curious too. We have probelms settign up SQL connections via dataflow that don't occur wiht a desktop connection. I'd like to know if the issue is gateway related, and if so, what the fix might be in that instance. Thanks in advance.
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
