Forum Discussion

Jerid421's avatar
Jerid421
Helper II
2 years ago
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...
  • Jerid421's avatar
    Jerid421
    2 years ago

    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())