Forum Discussion
Solved
Incremental Refresh from TE3 Gets Nebulous Type Conversion Error
Hello, I’ve been trying to implement IR on a model (which I’ve done many times). I have other models that operate with almost the same exact code (expressions and M Source Queries). But I am tryi...
This verifies what the problem is. By running this simple DAX query in TE3, I can reproduce the exact same error I was getting:
So, the answer here is, when employing this DAX-based dimDate table and refreshing an "empty" model (metadata-data only / freshly-deployed), to be sure to:- refresh a partition that you are sure has data in the source, first, before the other partitions
- include some error-trapping code in the DAX that accounts for instances where it might return an empty string (BLANK())
By the way, you can run Incremental Refresh with RangeStart and RangeEnd natively defined as date integers rather than DateTime.
When you say "natively", you mean without having to employ a function to convert them in the M Query?
correct. Read the Supported Data Sources section. Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn