Forum Discussion

shanerowley-ds's avatar
shanerowley-ds
New Member
2 years ago

Dataflow Fails Once and Then Credentials Are Perma-Broken

I have a dataflow that is getting data from an API. Sometimes the dataflow fails for reasons such as one of the services (the API or Azure) being unavailable. The failure has occured once each on consecutive weekends during a scheduled refresh. I can just ignore these refresh failures, perhaps even de-schedule the weekend refresh. The problem I'm having is, after this once off Dataflow failure, the Dataflow turns to this broken state, beyond my control and anything I've done, it starts to say the credentials are incorrect, even though they're not, and will auto-fail thereafter. And the only way it is; re-edit the Dataflow, clear credentials (both my 3rd party API and Azure connections are 'anonymous'). Sometimes that's not even enough. Sometimes I have to change the underlying Power Query superficially, without changing its function or output, just so Power BI unbreaks from its bugged state.