Dataflow Refresh failed :error

[schoden]

Hi Microsoft or any expert, 

From few days back one of my dataflow failed to refresh which was not the case earlier. 

The message showed: 

 Microsoft SQL: Warning: Fatal error 824 occurred at Jun 18 2020  3:14AM. Note the error and time  and contact your system administrator. Request ID: a8da7d7d-c22a-4bcf-8226-296c061ed2f9 Activity ID: b4653635-d863-46be-8133-e2b4f919291c

Can some one help me.

Thanks in Advance.

[v-deddai1-msft · Accepted solution]

Hi @schoden ,

Do you get Multi-Factor Authentication (MFA) enabled for the account? Please refer to  https://www.fourmoo.com/2019/02/13/why-is-my-powerbi-dataflow-refresh-failing/

If the datasource is sql server. Please also refer to  https://support.microsoft.com/en-us/help/2015756/how-to-troubleshoot-msg-824-in-sql-server

I would recommend you open a support ticket on the support.powerbi.com site.

Best Regards,

Dedmon Dai