Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |