Authenticating with Service Principal Credential - SQL Power BI

Question

I am using the App-Owns-Data embed scenario in a multi-tenant environment. Some of my paginated reports need a connection to Fabric Lakehouse.

When assigning a report to a tenant (copying the report from the master workspace) I need to patch credentials. I am using PowerBI API 4.16. - Gateways.UpdateDataSourcesAsync method. I am trying to patch the credentials of a service principal. I've tried to create credentials using basic authentication as well as OAuth2. I am unable to patch Service Principal credentials (receiving Unauthorized responses from the API. The same happen when I try Service Principal authentication over the Azure SQL database.

Answer 1

Hi,@MuthuKasi-MSFT Welcome to Microsoft Q&A thanks for posting your question

Did you add the Service Principal to the workspace and grant the SPN access to the appropriate tables in the SQL Endpoint?  Also, you don’t need a gateway to connect to the Fabric LH.  The paginated report should just run directly against the SQL Endpoint.

If this is in a customer tenant, you have to make sure the tenant switch is enabled to "Allow for Service Principals for PBI APIs"  

However SPN auth is not supported in GWs just yetService principal support to connect to data in Dataflow, Datamart, Dataset and Dataflow Gen 2 | Microsoft Fabric Blog | Microsoft Fabric

I hope this information helps

Regards

Geetha