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

[nicolas2828]

Any update ??

[TomT131]

Same issue here!

[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

[Anonymous]

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 @Anonymous,

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

[Rob92]

I also have this issue.  Any updates from Microsoft??

[holmesjs]

We are having this bug also.  @Anonymous  can you help loop in whoever from Microsoft would have a legitimate update?

[ericmao]

I ran into the same error. Anyone has an update from Microsoft Support?

Thanks in advance.

[dianaschnuth]

There are a few Ideas related to this that could use some upvotes: 

• Service Principal as authentication type for SharePoint folder 
• Add AAD Service Principal as a method of authentication
• Fabric SharePoint Data Connector for Microsoft Graph API using Service Principal Account
• Service principal with Power BI and Data Gateway

There are many more out there, but these were the ones that were most relevant to my own development needs. 🙂

[Anonymous]

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