Incremental Refresh

sarjensystems1 · ‎03-16-2020

hii

I have configured Incremental Refresh for the report and defined Parameters as below and i have data from 01-Apr-2017

RangeStart 01-Apr-17
RangeEnd 15-Mar-20 and filtered using the parameters

but when i have configured the incremental refresh and scheduled the dataset, it is taking around 37 minutes to refresh with incremental and

without incremental refresh it is refreshing with in 12 minutes.

Why is this happening???

Thanks

mwegener · ‎03-16-2020

What is your data source?

Does the query folding work?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

sarjensystems1 · ‎03-16-2020

Sql server Database is the datasource

v-lionel-msft · ‎03-16-2020

Please confirm if this is the reason:

The link:

Best regards,
Lionel Chen

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

sarjensystems1 · ‎03-16-2020

@v-lionel-msft no...i am facing issue with the subsequent refreshes

mwegener · ‎03-16-2020

but QueryFolding happens?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials