How to stop refresh on power BI website

[Anonymous]

Hi, I published a dashboard on the power BI webstie. There are some dax using today() function. So, when it comes to a new month, the data will auto change to a new month data, which is blank because I havn't refreshed on dataset. How can I stop this refresh and only showing the data like I published last time until I update the dataset.

[Mikelytics · Accepted solution]

Hi @Anonymous 

If I udnerstand correctly you can do the following.

Please create a calculated table with the following Code:

Calculated Tables are only updated during dataset refresh which means you now get in the table the date of the last refresh. you can on top of this table create the following measure which you can use for all further calculations.

M_LAstRefresh = SELECTEDVALUE(P_LastRefresh[Value])

So now your reference date will everytime be the date of the last refresh and when you dont refresh then you get the last available data.

For sure this means you have to stop the refresh when no data are available. If sthis does not work then you need to go with another approach where you check with a measure based on a specific criteria (e.g. are specific data vailable?) whether you want to go with TODAY() or with a past date.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn