cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
THEG72 Member
Member

DATA FLOWS INTERNAL ERROR RUN TIME INVALID DATE

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!

 

Capture.PNGData flow Refresh Error Log

3 REPLIES 3
agnaldocarmo Frequent Visitor
Frequent Visitor

Re: DATA FLOWS INTERNAL ERROR RUN TIME INVALID DATE

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

THEG72 Member
Member

Re: DATA FLOWS INTERNAL ERROR RUN TIME INVALID DATE

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

THEG72 Member
Member

Re: DATA FLOWS INTERNAL ERROR RUN TIME INVALID DATE

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.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,840)