Schedule Refresh BREAKER FUNCTION ✨| How To skip a date from Daily Schedule Refresh in Power BI

This Video will show you the way, how can you skip a refresh date with daily schedule refresh in Power BI. This may ne required many times, when you don’t want your power BI to get refreshed due to some maintenance activity on the database or some schedule process is under way, and there may not be any data.
for example don’t refresh on 1st day of the month or last day of the month


Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

We have posted many interesting Power BI solutions like below- Check it out on our Channel POWERBIHELPLINE

Follow us on LinkedIn
@PowerBIHelpline

[xyz_]

You always come with very different interesting video's

[edwinarchico]

Awesome, I learned something new today, I'm looking forward to your more videos ❤

[SNEHALGULHANE-ge]

I love your video's Thank you so much I don't know before yet 😍☺

[techinout]

Great Content, looking forward for more helpful videos.
Can you also make a video on how to refresh the data automatically every second. Thank you.

[sardhashakti]

Amazing,
I have a small query here:-
Have created a line chart with 2yrs of data using 2 measures (i.e year 2022 & 2023)
I have all week's data of year 2022 and since we just completed 16 weeks(isoweek) in 2023 so data is there till week 16. The issue is the line for year 2022 is showing all data from wk01 0wk52, but in 2023-line data is also showing from wk01 to wk52. from wk 01 to wk16 the numbers are correct bt future week sowing as 0.00%. Dax i have used as follows:
2023 = VAR DEL=CALCULATE([_DECat]/[_HAWBCount], DimDate[ISOYear]=2023)

RETURN
IF(ISBLANK(DEL), 0, DEL)

Need help to hide future weeks and once the latest week data is available for 2023 then till line show value instead of wrong data for future weeks.