Forum Discussion

ravsodhi's avatar
ravsodhi
Microsoft Employee
2 years ago

Azure Synapse Analytics - Connect via Service Principal

The documentation here suggests that it is possible to connect to Azure Synapse Analytics via a service principal.   But I do not see the option to do that on PowerBI Desktop H...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Use Windows auth ?

  • ravsodhi's avatar
    ravsodhi
    Microsoft Employee
    2 years ago

    lbendlin I cannot use Windows Auth, Basic, or Organizational account flows for my use case. How do I connect using service principal?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,

      Thanks for the solution lbendlin  provided, and i want to offer some more information for user to refer to.

      hello ravsodhi, based on your description, in Power BI Desktop, it cannot use the service principal for authentication directly, if you want to use this, you consider to use web connector, then set the token as a paramater to be used in power query, you can refer to the following link.

      Connect with Power BI to the Power BI REST API with a Service Principal – PBI Guy (pbi-guy.com)

       

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.