Forum Discussion
Incremantal refresh cannot setup
I have setop the Reange Parameters as below
The table that I want to setup is supporting Query folding as well which I can confirm this way:
In the Custom Fileters on date/time field I could not see the parameter that I created which are RangeStart and RangeEnd to setup the on the filed. I cross checked and conform that the type of Voucherdate, RangeStart, RangeEnd are date/time fields
Is there anything I am missing in the process to settings. Please guide me
Hi anusha_2023
It looks like you are triyng to filter out rows in a Table view in Report desing mode.
Configure these filter in Power Query Designer (a window in which you configured data sources and parameters)
Hello anusha_2023 ,
For ınceremental refresh you need to follow the query folding issue. İt seems you accomblished it. The next step is create RangeStart and RangeEnd from manage parameters in Power Query.After that you need to filter your date/time column.
Lastly, create incremental refresh policy.
More information about incrementel refresh one by one you can follow the link:
target=_blanktarget=_blankhttps://medium.com/microsoft-power-bi/power-bi-hidden-treasure-incremental-refresh-7e91ac79fc6aKind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
2 Replies
Hi anusha_2023
It looks like you are triyng to filter out rows in a Table view in Report desing mode.
Configure these filter in Power Query Designer (a window in which you configured data sources and parameters)
Hello anusha_2023 ,
For ınceremental refresh you need to follow the query folding issue. İt seems you accomblished it. The next step is create RangeStart and RangeEnd from manage parameters in Power Query.After that you need to filter your date/time column.
Lastly, create incremental refresh policy.
More information about incrementel refresh one by one you can follow the link:
target=_blanktarget=_blankhttps://medium.com/microsoft-power-bi/power-bi-hidden-treasure-incremental-refresh-7e91ac79fc6aKind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |