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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
RobThrive
Resolver I
Resolver I

Service account login to Sharepoint Folder

Hello all,

 

We have recently started to move the business onto Sharepoint Online. I'm trying to get Power BI (desktop/Hosted server, not service!) to access an excel file on a sharepoint team-site documents folder.

 

The problem I have: I am trying to use a service account to connect to that sharepoint folder via Power BI, but when I use the organsiation login option it tells me the user cannot login (which I understand is standard for service accounts). When I try to use a windows login and provide the correct username + password, I get told the user isn't authorised to access the file. This is despite the fact I've even created a group (and placed the svc account into it) and given that group complete full access to the sharepoint site.

 

Is it just not possible to use a service account for this? or is there something I'm not doing correctly?

If it makes a difference, this is using Azure A/D, all o365 based.

 

Many thanks

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@RobThrive 

 

You may check if the following post helps.

https://community.powerbi.com/t5/Power-Query/SharePoint-online-to-PowerBI-incorrect-permissions/m-p/...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
hawke
Frequent Visitor

Hi Rob, did you ever figure out a solution for this?  We are having the same issue.  I clicked on the link that was suggested, but that isn't the issue we are having. Our issue is that we aren't able to login using the service account without getting an error message.  If you were able to resolve the issue, please let me know what you did.

 

Thanks!

v-chuncz-msft
Community Support
Community Support

@RobThrive 

 

You may check if the following post helps.

https://community.powerbi.com/t5/Power-Query/SharePoint-online-to-PowerBI-incorrect-permissions/m-p/...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.