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: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

peter_bengtsso2

Service Principal as authentication type for SharePoint folder

Submitted by on ‎03-26-2024 08:06 AM

We urgently need Service Principal as authentication type for SharePoint folders in Power BI Service (when creating connections that will be used in a gateway). It's available for SharePoint Online lists.

Status: New
See more ideas labeled with:
7 Comments (7 New)
Comments
wbutler1
New Member
‎11-25-2024 05:50 AM

Agreed -- we have data files (excel, csv, txt) in sharepoint folders and need to access them from PowerBI. Ideally, we want to do this via a service principal account rather than individual accounts. Sharepoint lists are insufficient -- we have hundres of dynamic files and cannot convert them to lists.

Jakub_Tic
New Member
‎01-30-2025 02:57 AM

I'm facing similar issue. Since it's working for sharepoint lists would be great to have it also for sharepoint folders.

Anne_Lebel
New Member
‎01-31-2025 07:19 AM

Yup, just commented on another idea where this was mentioned. Need this for files as well as users will then OAuth when Get Data from Web from the Sharepoint folder is used as a source.

fbcideas_migusr
New Member
‎02-25-2025 12:45 PM
Status changed to: New
 
surangatj
Frequent Visitor
‎07-14-2025 05:55 AM
Yeah!! better if we have Service Principal auth for SharePoint folders, not just lists. Since it already works for SP lists, please extend to folders too.
data_nik
Regular Visitor
‎11-16-2025 10:24 PM
We also need this urgently! Perfect way would be via Workspace Identity also!
abreeze
New Member
yesterday
Just spent the better part of a month trying to setup a SPN for a SharePoint site connection for Power BI only to be told it's not supported! Documentation on this is also lacking - our local Microsoft support team also did not know about this. Organisations have a legitimate reason to need SPNs instead of a user account to connect to their data. - Users leave - Reports are built and managed by teams - SharePoint is sometimes the only acceptable storage option - you don't want a fake user to hold a Power BI licence - you want to schedule data refreshes - you want least privilege security without having to deal with password resets (service accounts) All of these are reasons and more why organisations don't want to use OAuth or service accounts as the authentication method. Please expedite SPN support for SharePoint Online Folders ASAP.