topic Re: SharePoint data source - authentication method service principal in Developer

SharePoint data source - authentication method service principal

naelske_cronos — Wed, 06 Dec 2023 15:51:30 GMT

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

Re: SharePoint data source - authentication method service principal

Anonymous — Fri, 08 Dec 2023 07:54:22 GMT

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

Re: SharePoint data source - authentication method service principal

naelske_cronos — Fri, 08 Dec 2023 08:02:28 GMT

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

Re: SharePoint data source - authentication method service principal

Anonymous — Fri, 29 Dec 2023 09:39:04 GMT

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

Re: SharePoint data source - authentication method service principal

naelske_cronos — Tue, 02 Jan 2024 07:56:49 GMT

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

Re: SharePoint data source - authentication method service principal

Marin_e_ — Wed, 17 Jan 2024 16:27:37 GMT

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.

Re: SharePoint data source - authentication method service principal

sheepworrier — Wed, 17 Jan 2024 16:53:46 GMT

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

Re: SharePoint data source - authentication method service principal

iga_DiP — Fri, 08 Mar 2024 12:28:52 GMT

Hi,

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

Thanks in advance!

Iga

Re: SharePoint data source - authentication method service principal

2win2mac — Wed, 08 May 2024 18:47:19 GMT

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

Re: SharePoint data source - authentication method service principal

Rob92 — Wed, 26 Jun 2024 20:09:37 GMT

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

Re: SharePoint data source - authentication method service principal

holmesjs — Thu, 27 Jun 2024 17:40:08 GMT

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

Re: SharePoint data source - authentication method service principal

ericmao — Thu, 25 Jul 2024 17:32:44 GMT

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

Thanks in advance.

Re: SharePoint data source - authentication method service principal

TomT131 — Sun, 15 Dec 2024 22:36:43 GMT

Same issue here!

Re: SharePoint data source - authentication method service principal

dianaschnuth — Wed, 12 Feb 2025 17:16:43 GMT

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

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

Re: SharePoint data source - authentication method service principal

nicolas2828 — Sat, 17 May 2025 07:48:56 GMT

Any update ??

Re: SharePoint data source - authentication method service principal

Yann44 — Wed, 01 Apr 2026 06:23:53 GMT

Hello,

Is there a solution for this topic?

I am also getting an error (error 400 : the credentials are invalid) while trying to use a principal service to authenticate a semantic model (with a Sharepoint site).

Thanks in advance.