Forum Discussion

dualsweat's avatar
dualsweat
Frequent Visitor
6 years ago
Solved

Power_BI Incremental Refresh Parameter Error(s)

Hello All,                      I am a relatively new POwer_BI n00b, but I have the "premium" license and I am trying to setup incremental refresh on a large dataset stored in an Azure blob. The dat...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi dualsweat ,

    I think this issue should more relate to your custom functions. 

    It seems like your query tables are generated from custom functions and you modify these parameters to Rangestart and RangeEnd with DateTime type. (I guess custom function require binary type records to do merge operations) Obviously, new DateTime parameters don't work on the original function to generate merged tables.
    I'd like to suggest you create two new parameters to store date/time value and use on the query table as incremental filters.
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi dualsweat ,

I think this issue should more relate to your custom functions. 

It seems like your query tables are generated from custom functions and you modify these parameters to Rangestart and RangeEnd with DateTime type. (I guess custom function require binary type records to do merge operations) Obviously, new DateTime parameters don't work on the original function to generate merged tables.
I'd like to suggest you create two new parameters to store date/time value and use on the query table as incremental filters.
Regards,

Xiaoxin Sheng