Restrict the data load

[Anonymous]

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 I want the data to be loaded till 24-Jan-2021 since the week has been completed till 24-jan-2021 and 28 is in between the week of 25-jan to 31-jan which is not completed.The week starts from Mon-Sun.

Thanks in advance,

[amitchandak]

@Anonymous , is it for a refresh or incremental load.

You can use query parameters

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

[Anonymous]

Hi @amitchandak ,

It for a refresh

[Icey · Accepted solution]

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.

[amitchandak]

@Anonymous , I think you have to explore Query parameters