Forum Discussion

aume1's avatar
aume1
Helper I
5 years ago
Solved

Incremental Refresh not working when data is updated

Hi,    I've recently created a test report to see if Incremental Refresh works with PBI Pro connected to MS Blob Storage. The data is imported as .parquet file. There are two reports (exactly the s...
Need Help
  • aume1's avatar
    aume1
    5 years ago

    Hi v-xulin-mstf , 

     

    I've managed to fix the problem by extending the refresh period from 3 days to 2 months, store period to 3 months! I'll mark this thread as solved. Thanks for the guidance!

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi aume1,

 

 In any case, your data source must support Query folding if you want to apply Incremental Refresh.

Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.

You can also use the Power Query Diagnostics feature or trace queries by using a tool supported by the data source, like SQL Profiler. If query folding is not occurring, verify the filter logic is included in the query being passed to the data source. If not, it's likely the query includes a transformation that prevents folding.

For more information, please refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#query-folding

https://docs.microsoft.com/en-us/power-query/power-query-folding

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!