Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
can you check if that service account exists in your organization's active directory? You can
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
|
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.
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.
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.
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.
can you check if that service account exists in your organization's active directory? You can
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
|
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 44 | |
| 16 | |
| 15 |