Forum Discussion
Solved
Dataflow OAuth Connection Error – Unable to Update API Login
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.co...
The problem was caused by an expired client secret on the API side.
Renewing the secret and using basic authentication with the secret works.
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
- Navigate to Settings → Gateway → Manage Connections.
- Locate the connection used by the dataflow.
- Delete the old connection and create a new one:
- Type: Web.
- Authentication method: OAuth 2.0.
- Enter the URL and credentials again.
- 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 🌀.