Connect to Sharepoint with Service Principal

[Ben44]

Hi,

If you have a Sharepoint as a datasource, the UI suggest that you can connect to if with Service Principal : 

But it's impossible. We get this error message each time : 

Failed to update data source credentials: The credentials provided for the SharePoint source are invalid. 

Is it possible to fix this ?

Thank you.

Ben

[Anonymous]

Hi @Ben44 ,

Here are the steps to use a Service Principal with SharePoint:

Create a Service Principal: Service Principals are created as an app registration in the Azure portal or by using PowerShell. When creating your Service Principal, be sure to copy and save separately the app name, application (client) ID, directory (tenant) ID, and client secret.
Create a Microsoft Entra security group: By default, service principals have access to any tenant settings they’re enabled for. To restrict service principal access to specific tenant settings, you can allow access to specific security groups.
Enable Service Principals: Before you can start using service principals in Power BI, an admin must enable service principal access in the Power BI Admin portal.

After the above steps, you can add the service principal to your workspace.

For more you may refer to：

Automate Power BI Premium workspace and semantic model tasks with service principals - Power BI | Mi...

Best regards.
Community Support Team_Caitlyn

[Ben44]

Hi,

Thank you.

I already did all theses steps, without success. 

I'm not the only one having this issue (example : https://community.fabric.microsoft.com/t5/Service/Adding-a-SharePoint-data-source-with-a-service-pri...)

Did you manage to make it work ? 

Ben

[pichlerpa]

@Ben44I provided the solution in the link you posted: https://community.fabric.microsoft.com/t5/Service/Adding-a-SharePoint-data-source-with-a-service-pri...