Scheduled Refresh on Power BI Service

[ncbshiva]

Hi all,

I have case like , i have to create a scheduled refresh and data should refresh on every day and it should not refresh on 1st of every month. Because i have used current month offset visual filters in my reports to show data only for the current month. And the data will be loaded into the database only to the next day that is 2nd.

So if the dashboard refreshes the data , my visuals become empty because my database does not have current month data.

Is there any solution to solve this problem ?

Thanks

[Anonymous · Accepted solution]

Hard to know exactly the cause without knowing the small details within your data sources, but your refresh will happen on the 1st even if you don't want it too.

Instead i'd suggest building something into your Query logic that should it be the first of the month, it should continue to ask run the procedures for the previous month, if thats possible.

It sounds like on the first you are running some type of Month To Date query from your source and its providing you with empty results.