Incremental works with ODBC connection?

[brunozanoelo]

https://www.youtube.com/watch?v=03CLJib9O8s&t=321s

I´m following this video, but in my pbix I use ODBC connection, that seens to disable the incremental refresh, is that right?

I´m not seeing any option to choose parameters.

[dax]

Hi @brunozanoelo , 

As I know, datasource should support query folding, which are recommended to use incremental refresh. You need to check it by "edit queries", then  right click on steps to see whether you could view Native query. You coould refer to service-premium-incremental-refresh for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener · Accepted solution]

Hi @brunozanoelo ,

I think the problem is that the parameter has to be date / time and your column is of type date. You have to convert them.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

"While the data type of the parameters must be date/time, it's possible to convert them to match the requirements of the datasource."

Something like that.