Forum Discussion

pbi_dev_za's avatar
pbi_dev_za
Regular Visitor
2 years ago

New dataflow to "Azure Synapse Analytics Workspace" with service principal

Good day

I'm trying to create a new dataflow from within Power BI Service to an Azure Synapse Analytics workspace using the Azure Synapse Analytics workspace (Beta) connector. 

 

I am getting a non-descriptive error when trying to connect using a service principal, so I'm unsure of where I am going wrong. 
(screenshot below). When I connect with an organizational (Azure AD) account I am able to connect successfully. 


My organizational account and service principal both have the same rights:

 

  • Resource group - Owner / Contributor
  • Storage account - Owner/ Contributor/ Storage blob data contributor 
  • Azure synapse anaytics workspace - Owner / Contributor / Synapse Administrator 

 

When I connect using the same connector directly from Power BI Desktop, there is no option to connect with a service principal - you can only connect with an organizational account. 

Does the connector perhaps not fully support authentication with service principals yet (as I notice it's in Beta)? This would explain why service principal auth is not available from within Power BI Desktop. 


Any help or advice would be appreciated. 


Power BI setup steps 

Select Workspace

   -->+ New
   --> Dataflow
   --> Add new tables
   --> Azure Synapse Analytics workspace (Beta)

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pbi_dev_za ,

     

    Azure Synapse Analytics workspace (Beta) currently supports organizational account authentication. This connector supports access to all data in Synapse workspaces, including Synapse Serverless, Synapse On-Demand, and Spark tables.

     

    For more details, please refer to the documentation: Power Query Azure Synapse Analytics workspace connector - Power Query | Microsoft Learn

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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