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
Hi
I am actually trying to connect SQL SERVER DB from dataflows, i have provided all the credentials and db names to connect. but not successful as per snapshot.
can you pls suggest. do i need to install something before doing this procedure.
Regards,
Rajendra
HI rajendraongole1 ,
Did this issue only appears when you try to create dataflow? If you create a pbix report, did it works?
In addition, you can also try to use fiddler to trace processing request when you create dataflow.
Regards,
Xiaoxin Sheng
Hi
I tried to connect the same through desktop directly sql server. i didnt found any issue able to connect db successfully.
But the same way i tried to connect the same connections from dataflow from services. there i am facing error as shown below.
is that i need to check with any admins at my end ?
Please suggest
Regards,
Rajendra
Hi rajendraongole1 ,
I can't confirm the causing of issue because of less information. Can you please open a support ticket on support page to get better support from power bi team?(it is free for pro and above licenses)
submit a support ticket
Regards,
Xiaoxin Sheng
Hi,
We are premium users. I have tried all the ways to login from dataflow by adding our source DB. but no luck
i will create support ticket now.
Thanks for your help and support!!
Regards,
Rajendra