cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI Online Service today() not refreshing

I've created two columns using DAX formulas on Power BI Desktop, one is to calculate the number of days until a date listed in a separate column (using =[DATE]-today()) and the other is to return 1 or 0 depending on if there's 21 days until the listed date (using an IF function). The purpose is to be able to send an email alert when it's 3 weeks from the date listed. I think that I can do that with a card set to the max of the column returning 1 or 0 and send a Power BI alert for that card and use Microsoft Flow to send an email then. However, I can't get the column's formulas to update on ther Power BI Service. It updates fine each day (the "days until" steadily decreasing) in Power BI Desktop, but the number is frozen on the day I uploaded the report and dataset online. Even when I manually publish the report/dataset again from Power BI Desktop, the numbers don't update. How do I get the today() function, or any of the functions in the columns, to update on their own? Or is there a way I can schedule desktop to publish the report (if it will update the numbers) every day? If anyone has any better suggestions for how I can schedule an email alert to certain people 3 weeks from a listed date, that would also be very helpful!

Status: Needs Info
Comments
Community Support Team

Hi @liujessie39,

 

I will check my test mode tomorrow. BTW, did you set the scheduled refresh?

 

Best Regards,

Dale

Established Member
Status changed to: Needs Info
 
New Member

@v-jiascu-msft I did not, but I did look into it. Since it's only a table instead of an outside data source I wasn't sure if a scheduled refresh would be necessary or in what way to set it up. I considered if republishing from desktop would work but when I manually did so the numbers did not update online even though they were updated in desktop. 

Frequent Visitor

Hi liujessie39, did you manage to solve this issue? I have the same problem. I calculate a state based on TODAY() date, but my published report does not update. I have to reload it from the desktop everytime. 

The manual Refresh did not work either.

 

Thanks in advance!