Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

SamQC

Can't connect to dataflow (invalid token)

Submitted by Advocate I on ‎06-04-2023 06:21 PM

Hello,
My dataflows and my reports worked well for months but all of a sudden, I can't connect to my dataflow anymore. This message shows up:

SamQC_0-1685927948319.png


I am the administrator... What am I supposed to do?

Status: Investigating
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎06-07-2023 02:11 AM

Hi  @SamQC ,

 

Please check if the previous solution helps:

You likely have too many connections in your OAuth Connected apps. Go to the user setup page for the user account you are trying to log in with and scroll down to OAuth Connected Apps. Then, revoke all tokens for power query.

 

For original post ,you may refer to:windows 10 - Excel Power Query integration with Salesforce: The Service Returned an invalid token - ...

 

Best regards.
Community Support Team_Caitlyn

SamQC
Advocate I
Advocate I
‎06-08-2023 03:19 AM

Hello,
Thank you @Anonymous for investigating.
Actually, I am not sure that we are talking about the same problem. The link that you shared is about Salesforce but I do not use this Software. My problem is really just that I can't connect to my Power BI Service Dataflow with my Power BI Desktop, nor with Excel.

 

I tried to find OAuth Connected Apps on Microsoft Manager but I couldn't find anything... I also tried to look for tokens but nothing... Am I looking at the right place?

BTW, I use Power BI Premium Per User (not Per Capacity).

Thank you again for your help!

marlonsalatiel
New Member
‎06-26-2023 07:09 AM

I was facing the same issue, and I had no clue what could've happened, until now.

 

I tried literally everything, and nothing worked...

For some reason I changed the wifi network and it got back normally. So I suppose some network configuration on previous one was blocking the access...

 

You should try this. Connect on your personal mobile access for example, and try again. It may fix and you'll confirm the issue is not on your power bi credentials.

 

I hope this helps. Regards.

SamQC
Advocate I
Advocate I
‎07-04-2023 06:09 PM

Thank you @marlonsalatiel !

 

I tried to connect to a different wifi network and it worked.

Rodger_Ct
New Member
‎04-22-2025 03:50 PM
I used to be able to connect to dataflows but now I can't. And another colleague has the same issue. Microsoft please provide some reason as to why this may be happening. The invalid token message is not helpful. We are on the government cloud with Pro licenses and capacity. I have removed credentials, tried using other peoples machines. Why would it just stop working for some of us?
SamQC
Advocate I
Advocate I
‎04-23-2025 12:17 AM
@Rodger_Ct Have you tried connecting to a different Wifi?
Idea Statuses