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


How can I connect without using account-based authentication?

Need Help

3 Replies

    • 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.