Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

naelske_cronos

SharePoint data source - authentication method service principal not working

Submitted by Helper III on ‎12-07-2023 04:35 AM

It seems that the authentication method 'service principal' does not work for the SharePoint datasource in Power BI service -> dataset -> settings - edit credentials. By reading some documentation it seems that the only way to get data from the SharePoint API is via client certificates, maybe why it does not work (anymore) for client secrets. I presume this uses the SharePoint resource 'https://microsoft.sharepoint.com' and not the Graph resource 'https://graph.microsoft.com/' under the hood.

Capture.PNG

 

Kind regards

Status: Investigating
See more ideas labeled with:
9 Comments (9 New)
Comments
Anonymous
Not applicable
‎12-07-2023 06:27 PM

Hi  @naelske_cronos 

I found a document related to connecting to SharePoint using service principal that you can refer to. Hope this will help you.

How to connect SharePoint online using service principal? - Microsoft Q&A

 

Best Regards,
Community Support Team _ Ailsa Tao

naelske_cronos
Helper III
Helper III
‎12-08-2023 12:04 AM

Hello,

 

Thank you for the links but I don't see how this helps me with this example with setting the credentials in the Power BI service. The link you showed talks about how to do this with PowerShell and most of blogs are talking about certificates and not client secrets.

Picture1.png

Capture.PNG

 

Is there a possibility to test this out and tell me what I exactly need to get this working to get this working in Power BI service for SharePoint?

 

Thanks in advance

Kind regards

sheepworrier
Frequent Visitor
‎01-17-2024 07:12 AM

Any update on this one please?  I have the same issue

Mariza
New Member
‎04-10-2024 04:43 PM

Did you find a solution to this? I'm having the same issue

Marizach
Frequent Visitor
‎04-12-2024 11:33 AM

@naelske_cronos Did you happen to get this to work? I'm facing the same issue and wanted to know if those permissions you granted the service principal would be enough.

mobiandra
Frequent Visitor
‎07-22-2024 06:53 AM

same issue here

ericmao
Regular Visitor
‎07-25-2024 10:40 AM

same issue when using client secret. anyone has got it resolved?

Stefaan-4365
New Member
‎10-19-2024 10:00 AM

I'm facing the same issue. Any updates?

Stefaan4365_0-1729357166976.png

 

michaelstoecker
Regular Visitor
‎01-09-2025 11:52 AM
I am facing also the same issue! my app registration (service principal) has granted those rights: Microsoft Graph (1) Sites.ReadWrite.All SharePoint (1) Sites.FullControl.All
Idea Statuses