Forum Discussion
Dax Today() & Now() becomes a static value after published to portal
Community SupportHi lu8890 ,
the calculated columns are computed during the database processing and then stored in the model. So if you want the dynamic TODAY() and NOW() function, we can create a measure to use it and the value will change every time user load the report or refresh the page. But if your another calculated column related on it, it will still refresh only on data refresh.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think I figured out what the issue is.
It looks like the reason why my table won't refresh in portal, is because the credential to access data set (a .csv host in Cosmos14) is failing. I am having proper permission to access this file directly via cosmos, vsts, and the same report on power bi desktop doesn't have any issue. However, I am not able to get authenticated in Power Bi portal. Any suggestions?
- GilbertQ
Super User
Hi there
In order to access the data, you will need to install and configure the Power BI Enterprise Gateway.
Once it is installed, configured and set up the Data Source, you will be able the schedule a refresh which will be the same as when you click on the Refresh button in Power BI desktop.
