Forum Discussion
Post PartisanToday's date not refreshing in Power Bi Service
Ok then the TODAY() in your formula is good. did you replace 1 by 2 or 3 or... in the M code?
let
Source = List.Dates(StartDate, Length+2, #duration(1, 0, 0, 0)),...
doing so, you should be good.
Post PartisanSorry about thtat.
Yes, I replaced +1 in the M code with +2 andthe calender is now showing-
The card visual is good and still showing 7/7/2021.
Just last question, does this mean I still have to change time in browser and the desktop etc.
Thanks
Community ChampionYour Desktop and system is ok according to the measure TODAY you put in the card. The browser i am not sure, check it out.
However what I am suspecting is that you are not using a Gateway to refresh you report. Did you install a Gateway? Does the refresh in your desktop give you the correct data into your visuals?
- aj1973
Well after you corrected the M Code, republish the report to the service and manually refresh it. The visuals should be corrected as well.
- learner03
Sure, will do.
Thank you so much for your time and effort.
Thanks again
- learner03
So when I refreshed desktop in morning, then only calander populated today's date and I got correct result in Desktop.
I installed gateway and below is the screenshot-
In the morning, the scheduled refresh was successfully complted but the only problem was that, it did not show Today's result and the calander did not populated today's date and was showing 6th july only instead of 7th July.
- aj1973
Yeah it's about time to go to bed.
You welcome