SharePoint data source - authentication method service principal

[naelske_cronos]

Hello,

I see that the authentication method 'service principal' can be used to authenticate to SharePoint Online but it does not seem to work for me to authenticate. My data source is just a List in SharePoint Online.

These are the permissions that I have. Which permissions do I need more to get this working?

Kind regards

[2win2mac]

I am still having the same issue. When is Microsoft planning to fix this bug?

[iga_DiP]

Hi,

I'm having the same issue. Does anybody have more info on this topic now?

Thanks in advance!

Iga

[v-shex-msft]

Hi @naelske_cronos,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[naelske_cronos]

Hello @v-shex-msft,

I have discussed this issue with Microsoft Power BI support and it is a bug that should be looked at from their side.

Kind regards

[Marin_e_]

Hello @naelske_cronos ,

Do you have more details regarding this bug ?

Will Microsoft Power BI team fix the Service principal authentication method for a SharePoint connection ? If yes, do we have an idea when ?

Thank you in advance.

Best regards.

[sheepworrier]

I have also encountered this issue and would be interested in hearing if there's any way to track progress on it with Microsoft

[v-shex-msft]

Hi @naelske_cronos,

The snapshot shows the error message that provided credentials is invalid. Did you used the same type of credentials when you design power bi report and connection to the data source?

AFAIK, they should be matched or these credentials not able to be used and power bi will also notice credentials are invalid.

Regards,

Xiaoxin Sheng

[naelske_cronos]

Hello,

In Power BI desktop it is not possible to use service principal as authentication method, only in Power BI service.

It is working via the other authentication methods like OAuth2 but not via the service principal?

Kind regards