Forum Discussion

Bodyes's avatar
Bodyes
Regular Visitor
10 months ago
Solved

Authentication to Sharepoint via Workspace Identity

Hi We have an issue with connection to our SharePoint site to get data from it to our PowerBi. We have created a PowerBI workspace and we want to use Workspace Identity as an authentication method ...
Need Help
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi Bodyes,

     

    Today, those SharePoint connectors don’t support Workspace identity, so the Service can’t acquire a token with that auth type and you get “The credentials provided for the SharePoint source are invalid.”

    Quick solution
    1) Don’t use Workspace identity for SharePoint (for now). Use a Service Principal (“app-only”) or a standard Organizational account.
    2) You do not need Premium just to refresh a dataset that reads SharePoint with a Service Principal. Pro is fine.
    3) If you choose Service Principal, grant it “Sites.Selected” on both Microsoft Graph and SharePoint, and then explicitly grant the app access to the specific site. Finally, set dataset credentials in the Service to OAuth2 > Service principal.

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

tayloramy's avatar
tayloramy
Super User
10 months ago

Hi Bodyes,

 

Today, those SharePoint connectors don’t support Workspace identity, so the Service can’t acquire a token with that auth type and you get “The credentials provided for the SharePoint source are invalid.”

Quick solution
1) Don’t use Workspace identity for SharePoint (for now). Use a Service Principal (“app-only”) or a standard Organizational account.
2) You do not need Premium just to refresh a dataset that reads SharePoint with a Service Principal. Pro is fine.
3) If you choose Service Principal, grant it “Sites.Selected” on both Microsoft Graph and SharePoint, and then explicitly grant the app access to the specific site. Finally, set dataset credentials in the Service to OAuth2 > Service principal.

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

yashaswi_raj's avatar
yashaswi_raj
Helper I
10 months ago

Hi tayloramy , 

can you explain this -then explicitly grant the app access to the specific site. 
how to do it 

  • tayloramy's avatar
    tayloramy
    Super User
    10 months ago

    Hi yashaswi_raj, 

    This is done with the legacy permissions page: /_layouts/15/appregnew.aspx

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.