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

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    7 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am facing the same problem. Connecting to SQL server database via PowerBI desktop works fine. When I try to connect via dataflow it gives me the following error;