Unanswered

PowerApps Platform Dataflow is failing

(0) Share

Report

Posted on by devcoder Microsoft Employee

Hi,

We are using Power Platform Dataflow from Azure SQL to CDS entity to sync data. The auto refresh settings for this data flow is generally worked well. But now we have started getting error as per screen-shot attached while updating auto refresh setting. I have tried this multiple times but same error. Azure SQL server credentials are valid.

The similar error is coming up while setting "Refresh Manually" but it is cleared out eventually and proceed to save setting.

Categories:

Microsoft Dataverse with Power Apps

Auto Refresh Erro...

I have the same question (0)

All responses (6)

Answers (0)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @devcoder, are you sure it's not an authentication issue, where either the invalid credentials, locked account or MFA is enabled and is expecting someone to approve the login? Suggest to retest with a simple Dataflow using the same account to isolate the issue.

Was this reply helpful? Yes No
devcoder Microsoft Employee on at

Like (0)

Report

Hi,

Thank you for feedback !!

I have tried simple dataflow which connects to Azure SQL using SQL Server Authentication and select "Do not load" to CDS entity option by enabling auto refresh settings. This fails as well.

If it is an authentication issue, then "Refresh Manually" would not work as well. But with this setting, the errors come up but cleared automatically and sync happens afterwards.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Strange, did you try another browser like Edge? I would submit a Microsoft support ticket at https://admin.powerplatform.microsoft.com/support

Was this reply helpful? Yes No
devcoder Microsoft Employee on at

Like (0)

Report

Yes I have attempted retest using Edge.

Was this reply helpful? Yes No
Tin 12 on at

Like (0)

Report

Hi @devcoder, Do you know how to Send email notification while dataflow is failure?

Was this reply helpful? Yes No
pavanmanideep 493 Power Up Champ - 2025 on at

Like (0)

Report

Hi @rtomar377 ,

You can setup notification when your dataflow fails, you may refer to this article

https://learn.microsoft.com/en-us/power-query/dataflows/send-notification-when-dataflow-refresh-completes

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No