Hi, I am receiving the following error when attempting to do an incremental refresh on a recently published dataset to the Power BI service. I can see that the error appears to be related to converting a null entry to Date type, however I can't for the life of me work out which table this relates to. I have patched a few queries up to ensure blank rows are removed, but my dataset contains many other date fields (most of which are imported from an SQL query), and I have no idea how to trace it back. Does the error code below give any insights?
Thanks!
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We cannot convert the value null to type Date."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-AUSTRALIA-EAST-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 138dc271-de47-3900-a8ac-55c98e1e4b5a
Request ID: 9ca7cc20-492c-8307-427e-5d6c3ceb7858
Time: 2023-06-05 19:46:19Z
