Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

Incremental Refresh - First scheduled refresh duration and cached data usage

I configured Incremental Refresh (6 months + 1 day) for my dataset connected to an Oracle source. Here’s what I did: *Loaded 6 months of historical data in Power BI Desktop (it took ~15 hours due t...
Need Help
  • blopez11's avatar
    blopez11
    10 months ago

    1. No.  2. No. it will do full refresh  3. Yes.

    Incremental refresh doesn't work they way you are trying to use it.

    For incremental refresh,

    - You configure the incremental refresh in the desktop (creating range parameters, using them in the table you want incrementally refreshed, etc..

    - Publish to to Service.

    - The first refresh in the Service creates the partitions, loads historical data, etc.  This first refresh can take a bit of time.

    - Subsequent refreshes will be incremental based on the policy you created.

     

    You can avoid the first refresh taking so long by bootstrapping the initial refresh.

    Check out the Guy in a Cube video: https://youtu.be/5AWt6ijJG94?si=25aIgwS6NCUDIgEI

     

    Regards,

     

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi Anonymous ,

Thank you for reaching out to the Microsoft fabric community forum.

 

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by blopez11   . If you still require support, please let us know, we are happy to assist you.

 

Thank you.