Service Returned an Invalid Token

[Tekell09]

I'm simply trying to connect to a Sharepoint Online List. It's worked well until recently. I cannot figure out how to cure the below error message. I have cleared permissions, signed in and out and back in. 

How do I properly connect to this data source ? 

[lbendlin]

Did you contact your IT administrator?

[Tekell09]

We're a 2-person company right now, we don't have IT. 

[lbendlin]

Who is maintaining your Entra ID?

[Tekell09]

 

I would say that I am maintaining it myself. Does the below tell us anything else ? 

[lbendlin]

Any recently expired certificates?

[Tekell09]

This is what I see when I click on the address bar under connection details:

Issued On

Wednesday, May 29, 2024 at 3:16:14 PM

Expires On

Saturday, May 24, 2025 at 3:16:14 PM

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[Tekell09]

I appreciate your help and direction. I opened a Pro ticket but we could not solve the issue. I'll raise the issue at the link you provided. 

[lbendlin]

 I opened a Pro ticket but we could not solve the issue.

Wait what?  That is not supposed to happen. Did you ask them to escalate to the product group?

[Anonymous]

Hi @Tekell09 ,

Have you solved your problem with support ticket? If solved can you reply with the solution below and mark it as solution so that other users can find it faster?

Best Regards,
Dino Tao

[othoncps]

I'm experiencing this same issue. Trying to connect, in Power BI, to OData Feed using a given URL.

[AleksandarMalic]

I managed to solve this issue by updating Power BI web services. Find your workspace and your data model and click on settings. After that click on Data source credentials, then Edit credentials and select OAuth2. Sign in again using your Credentials and restart your PBI file. Hopefully this will fix your issue!

[sambrakas144]

I fixed this by performing the following steps

1 uninstalled Power BI Desktop

2 Deleted the Power BI Desktop Microsoft Store folder on C drive, uninstalling PBI desktop does not remove most of these folders/files.

3 Restarted computer

4 Installed PBI desktop from Microsoft store

[BIbigbox]

It worked for me. Thanks

[JonathanS1726]

I was able to fix this in a very simple way, and it seems the issue is related to authentication.

When you try to edit the permissions, Power BI prompts you to select an account. If you simply click on your listed account, you’ll likely end up seeing the same error again.

Here’s what worked for me:

1. When prompted to select an account, choose “Sign in with a different account.”

2. Then, enter the same account and password you were using before.

3. You might be asked to go through the MFA (Multi-Factor Authentication) process again.

4. Once completed, the token error disappeared and everything started working properly.

I hope this helps someone else facing the same issue!

[ctOS2025]

I tried all of the below - none worked. Fortunately my last permutation was successful and involved doing the following, I first went to File -> Options and settings -> Data Source settings. Selected each site which was having the connectivity issue and clicked Clear Permissions (Delete) so they vanished from the list. I then went through the motions of creating a new report:

1. Create Blank Report

2. Table -> Get Data -> More -> Sharepoint Online List -> Connect

3. Sharepoint Online Lists dialogue: Enter site url, select v2.0 implementation radio button -> Click OK

4. In the Navigator dialogue, from my Sharepoint online site i selected the list using the tick box and clicked Load.

5. By virtue of doing this (i.e. successfully logging in with my credentials to the original sharepoint online list), I tried opening the orginal pbix file which would always show "Service Returned an invalid token" or "The credentials provided for the SharePoint source are invalid. Please update the credentials through a refresh or in he Data Source Settings dialog to continue (Source at sharepoint.com/sites/SiteName)" and clicked the Refresh button. And as if by magic my report began to sync up the latest data from the list - the connection worked!

6. I found out that you don't actually need to save the blank report that I just created - I simply discard it.

The usefulness of this process is simply to re-initialise the Data Sources settings for the sharepoint site where the list(s) are located. This ensures the Global Permissions section of the Power BI desktop application is up to date and valid.

Hope this helps others. Chris.