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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Unknowncharact0
Regular Visitor

SharePoint Access

Hi,

how do I give access to SharePoint to "onmicrosoft.com" service account. When I try to grant access from SharePoint folder, I don't see that account listed, only "@company.com" accounts are there. 

thank you 

2 ACCEPTED SOLUTIONS
tharunkumarRTK
Super User
Super User

 can you check if that service account exists in your organization's active directory? You can

 

  • Open  https://portal.azure.com

  • Search for User from the global search bar at the top

  • View the list of all users in your Azure AD

  • Search for the specific service account

  • If you can find it, then it is part of your Azure AD; otherwise, it is not

  • If it is part of your Azure AD, you can grant access to it, regardless of whether it has a SharePoint or Microsoft 365 license

  • If it is not  part of your Azure AD, it is considered an external account. In that case, you should first invite it to your organization’s Azure AD as a B2B user. Once the invitation is accepted, the account will appear in your directory, and you can then grant SharePoint access or assign the necessary license.

    https://learn.microsoft.com/en-us/entra/external-id/what-is-b2b

     

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!


    PBI_SuperUser_Rank@2x.png
  •  

  •  

  •  

  •  

  •  

@Unknowncharact0

View solution in original post

Poojara_D12
Super User
Super User

Hi @Unknowncharact0 

When you try to give access to a SharePoint folder or site, you can only directly grant permissions to users or service accounts that exist within your organization’s Azure Active Directory (AAD) tenant and are recognized as valid members or guests of that directory. If your Power BI gateway or service principal uses an account with the “@tenant.onmicrosoft.com” domain, it may not appear in the SharePoint sharing dialog if it’s not a licensed or active user object in AAD. By default, SharePoint Online recognizes only authenticated directory users, so unless the “@onmicrosoft.com” account is explicitly added as a user in AAD (not just a service principal or app registration), it won’t appear in the people picker when you try to share folders or grant permissions.

 

To fix this, go to the Microsoft 365 Admin Center → Users → Active users, and check if the “@onmicrosoft.com” account exists as a user. If not, create a new user with that UPN or assign a license if required for SharePoint access. Alternatively, if the account represents an Azure App Registration (service principal) used by Power BI or another service, you can’t directly grant folder-level SharePoint access through the UI — instead, you must use Microsoft Graph or SharePoint API to grant app-only access by assigning the appropriate App permissions (Sites.Selected) in Azure and then granting the app permission to that specific SharePoint site using PowerShell or Graph API.

 

In short, if it’s a user account, make sure it’s an active AAD user; if it’s a service principal, use app-based permissions rather than trying to grant access through the SharePoint sharing dialog.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

View solution in original post

6 REPLIES 6
v-echaithra
Community Support
Community Support

Hi @Unknowncharact0 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

v-echaithra
Community Support
Community Support

Hi @Unknowncharact0 ,

Thank you @Poojara_D12 , @tharunkumarRTK   for your inputs.

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

Poojara_D12
Super User
Super User

Hi @Unknowncharact0 

When you try to give access to a SharePoint folder or site, you can only directly grant permissions to users or service accounts that exist within your organization’s Azure Active Directory (AAD) tenant and are recognized as valid members or guests of that directory. If your Power BI gateway or service principal uses an account with the “@tenant.onmicrosoft.com” domain, it may not appear in the SharePoint sharing dialog if it’s not a licensed or active user object in AAD. By default, SharePoint Online recognizes only authenticated directory users, so unless the “@onmicrosoft.com” account is explicitly added as a user in AAD (not just a service principal or app registration), it won’t appear in the people picker when you try to share folders or grant permissions.

 

To fix this, go to the Microsoft 365 Admin Center → Users → Active users, and check if the “@onmicrosoft.com” account exists as a user. If not, create a new user with that UPN or assign a license if required for SharePoint access. Alternatively, if the account represents an Azure App Registration (service principal) used by Power BI or another service, you can’t directly grant folder-level SharePoint access through the UI — instead, you must use Microsoft Graph or SharePoint API to grant app-only access by assigning the appropriate App permissions (Sites.Selected) in Azure and then granting the app permission to that specific SharePoint site using PowerShell or Graph API.

 

In short, if it’s a user account, make sure it’s an active AAD user; if it’s a service principal, use app-based permissions rather than trying to grant access through the SharePoint sharing dialog.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
tharunkumarRTK
Super User
Super User

 can you check if that service account exists in your organization's active directory? You can

 

  • Open  https://portal.azure.com

  • Search for User from the global search bar at the top

  • View the list of all users in your Azure AD

  • Search for the specific service account

  • If you can find it, then it is part of your Azure AD; otherwise, it is not

  • If it is part of your Azure AD, you can grant access to it, regardless of whether it has a SharePoint or Microsoft 365 license

  • If it is not  part of your Azure AD, it is considered an external account. In that case, you should first invite it to your organization’s Azure AD as a B2B user. Once the invitation is accepted, the account will appear in your directory, and you can then grant SharePoint access or assign the necessary license.

    https://learn.microsoft.com/en-us/entra/external-id/what-is-b2b

     

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!


    PBI_SuperUser_Rank@2x.png
  •  

  •  

  •  

  •  

  •  

@Unknowncharact0

anilelmastasi
Super User
Super User

Hello @Unknowncharact0 ,

 

You can assign it a Microsoft 365 license that includes SharePoint Online and then you can easily add. Also why do you want to give access to that service account? Can you give more detail?

It will support a power bi dashboard and one of the data sources is a sharepoint file. I just never had a service account that ended in @onmicrosoft.com so wasn't sure what to do from here. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.