app.powerbi.com refresh weekdays only - falls over when no data on closed days

[RedWineGirl]

Hi

We have scheduled daily reports from our MIS system into PowerBI. One of the reports is 'student attendance today' so there is no data of a weekend so the refresh fails and the schedule stops. Is there a way that we can either schedule for weekdays/school days only or do something in PowerBI to ignore empty tables?

Thanks

[RedWineGirl]

So obvious! I saw the weekly option and the days didn't display... all sorted now thank you!!

[blopez11 · Accepted solution]

You can specify the days of week that you want the refresh to execute on.  In the semantic model settings > Refresh section, change the Refresh frequency to weekly, and select the days you'd like.

Hope this helps,