Power_BI Incremental Refresh Parameter Error(s)

[dualsweat]

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 data set is hundreds of thousdans of small .csv files.

                   I initially set my report up to refresh daily, but after about a month it began timing out. It was at that point that I tried to setup incrememental refresh. Unfortunately, everytime I set it up, I can the same parameter errors. Does anyone know what these errors mean or how to fix them? Google and the forums have yielded some results, but nothing that relates directly to this error.

                  Here is the procedure I am following to set up incrememntal refresh: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

                 Here is a saved video of me setting up the parameters (along with the displayed error). I saved it on my OneDrive:

                 https://1drv.ms/u/s!AugiFDhJoAv-2P4kX3jK-qBUcLpW1g?e=IgEQy0

Any information is appreciated!

Thank You,

M---------

[v-shex-msft · Accepted solution]

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