Forum Discussion

emartinezh's avatar
emartinezh
Helper I
2 years ago
Solved

Problem connecting sql analytics endpoint to visual studio

Hello good morning and thank you in advance for your effort helping people. Since fabric appeared, in my company we're moving all our resources to the fabric environment, we're very excited with t...
data warehouse
  • emartinezh's avatar
    emartinezh
    Helper I
    2 years ago

    Hello AndyDDC.

    Finally I got the extraction connection active, i had to create the service principal with the video u post here.

    I attach the SDK connection string so somebody can takes this as help.

    string ConnectionString = @"Server=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.datawarehouse.fabric.microsoft.com; 
Authentication=Active Directory Service Principal; 
Encrypt=True; 
Database=LK_XXXXXX_XXXXXXX; 
User Id=xxxxxxxx-xxxxxx-xxxx-xxxx-xxxxxx; 
Password=xxxxxxxxxx";

    Where Database=The datalake to connect.

    UserID= Application ID of the service principal.

    Password= Secret of the service principal.

    Thank you

    Best Regards.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi emartinezh 

       

      Glad that you query got resolved and thank you for sharing the same with the community as you said it can be helpful to others. 

      Please continue using Fabric Community for further queries.

       

      Thanks.