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

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , I think you have to explore Query parameters

    • 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.