Dataflow OAuth Connection Error – Unable to Update API Login

[LuITS]

Hello,

i have a dataflow gen1 connecting to an api. The Flow run succesfull for some time.

I used a web connection with OAuth 2.0 Authentification.

URL: https://go-api.avepointonlineservices.com/admin/report 

Now the Flow fails due connection errors. But when i try to edit the connection in the flow, it wont let me switch the used account. 

I get error "Failed to login with OAuth token. Please try logging in again." 

And when i try to use the account i am signed in witch i get error "Unable to create connection using an organizational account, please check to see if the data source path is correct and that the data source supports using an organizational account."
 

When trying to change the connection ouside of the flow under "manage connections and gateways" i get error 

"Unable to start OAuth login for this data source. Failed to login with OAuth token, please update the credential manually and retry.Details: The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer'. Please have this information handy if you choose to create a support ticket."

-Why did the flow stop running in first place with the given credentials?
-Why can't i edit the connection in the dataflow editor? 

Thank you

[LuITS · Accepted solution]

The problem was caused by an expired client secret on the API side.

Renewing the secret and using basic authentication with the secret works.

[Zanqueta]

Hi @LuITS,

This issue is relatively common in Dataflows Gen1 when OAuth authentication expires or when there are changes to the API endpoint.

Possible Solutions
Option A: Update credentials manually

1. Navigate to Settings → Gateway → Manage Connections.
2. Locate the connection used by the dataflow.
3. Delete the old connection and create a new one:
   • Type: Web.
   • Authentication method: OAuth 2.0.
   • Enter the URL and credentials again.
4. Return to the dataflow and associate the new connection.

Option B: Migrate to Dataflows Gen2

• Gen2 offers improved credential management and support for refresh tokens.
• It provides more stable authentication for external APIs.

Official Reference:

Introduction to Dataflows and Self-service Data Prep - Power BI | Microsoft Learn

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.