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
I have the same problem, and I have not found the solution until now.
@agnaldocarmo okay what was the secret sauce to fix the problem then?
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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!