Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Adding a SharePoint data source with a service principal

Hi,   I am trying to access files located in SharePoint Online. We would like to use a service principal for the authentication. But when I try to save the credentials I get the following error:  ...
Need Help
pichlerpa's avatar
pichlerpa
Frequent Visitor
1 year ago

Hey,

 

Setting the property "DisableCustomAppAuthentication" in your SharePoint tenant to "false" is doing the trick, you can use the following PS command :

Set-SPOTenant -DisableCustomAppAuthentication $false

 

The problem is that since November 27th, 2023 (depreication of Azure Access Control Services) this is set to "true" by default even though it's still working until April 2, 2026. The currently only (recommended) way is to use certificate-based OAuth2.0 authentication which won't work in the Power BI service though as it requires a local certificate to be integrated, seems to be kind of a technical debt the Power BI team has yet to address.

 

Hope this helps.

 

Patrick Pichler
Owner & Co-Founder

Teams: Chat with me
Website: www.creativedata.io
Follow us: LinkedIn | Medium
Data Management | Data Analytics & Reporting | Data Apps & APIs | Artificial Intelligence | EU Projects