DATA FLOWS INTERNAL ERROR RUN TIME INVALID DATE

[THEG72]

I have a data flow which will not refresh in the service. Note the invalid date in the runtime error logs attached.

The query is using the Web.Contents function to return a json file. The data source itself is an on premise API web source to an accounting system.

Refreshes function normally on demand or as a scheduled refresh when the data is imported as a dataset.

The same query as a Data flow will refresh inside power query and return valid results however once the query is saved and refresh is tried the refresh will fail per attached spreadsheets.

I use multi-factor authentication (MFA) on my account. 

I have tried disabling the MFA but this is not ideal and would make the data flow functionality limited.

Disabling it however did not resolve the problem however some have expressed that disabling, re-enabling after a day fixed the issue. I tried but still no luck

Anyway, hope that is enough information to get a solution!

Data flow Refresh Error Log

[agnaldocarmo]

I have the same problem, and I have not found the solution until now.

[THEG72]

@agnaldocarmo  okay what was the secret sauce to fix the problem then? 

[THEG72]

For other interested in this error, MS has identified a null in the code causing the problem. Have been advised fix to be deployed midweek by the engineering team.