Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Restrict the data load

Hi all,   I need your help in restricting the data while loading into power bi.I want the restrict the the uncompleted weeks data to be restircted to load. For e.g., If I have data till 28-jan-2021...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    There is one option in incremental refresh in Power BI - Only refresh complete periods.

     

    In your scenario, if could, try to set as below. When you set the incremental range to 7 days and schedule the refresh to run on the 1st day of the week. With this option checked, it would for example refresh weekly data on Sunday.

     

     

     

    Best Regards,

    Icey

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak ,

It for a refresh

 

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

There is one option in incremental refresh in Power BI - Only refresh complete periods.

 

In your scenario, if could, try to set as below. When you set the incremental range to 7 days and schedule the refresh to run on the 1st day of the week. With this option checked, it would for example refresh weekly data on Sunday.

 

 

 

Best Regards,

Icey

 

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