Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DuncanP
Advocate II
Advocate II

SharePoint list as delegated admin

Hi

 

I'm trying to connect to a SharePoint list that exists in the SharePoint Online site that we are managing for a client as a Partner Admin.

 

So I can sign in as me@mydomain.com and get access to their site theirdomain.sharepoint.com with full admin rights. However, when I select the SharePoint list data source in Power BI desktop and sign in with my organisational account, it tells me "The user was not authorized". The same happens if I use an odata feed to connect to the listdata.svc page.

 

So, can anyone confirm if it should be possible as a Partner Admin to connect to SharePoint lists in Power BI desktop, or do I need to do it as a user attached to their organisation?

 

Duncan

1 ACCEPTED SOLUTION

2 REPLIES 2
DuncanP
Advocate II
Advocate II

To clarify, as me@mydomain.com I can access https://theirdomain.sharepoint.com/sites/their_site/_vti_bin/listdata.svc and https://theirdomain.sharepoint.com/sites/their_site/_api/web/lists without issue via a browser. It's only when using Power BI desktop that the problem occurs. I guess it might be an oauth issue somewhere, but I've no idea where to even start.

 

Duncan

Probably linked to this idea?

delegated-admin-for-power-bi

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.