Forum Discussion
Error Message: Invalid date/time 2016-05-24 (from SQL)
Solved - before anyone gets too caught up in this, it turns out the error was from another dependant View on the View with the CONVERT(DATE)s... so forcing a recompile on the dependant View fixed the error.
Shame PowerBI can't say which table was causing the problem - that would have saved time, especially as the actual error itself was misleading. Maybe this will help someone else grinding over similar.
TTFN,
Phil
Thank you very much for sharing the solution. You saved my day!
Solved - before anyone gets too caught up in this, it turns out the error was from another dependant View on the View with the CONVERT(DATE)s... so forcing a recompile on the dependant View fixed the error.
Shame PowerBI can't say which table was causing the problem - that would have saved time, especially as the actual error itself was misleading. Maybe this will help someone else grinding over similar.
TTFN,
Phil
Thank you very much for sharing the solution. You saved my day!