Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Wrote a measure as a "welcome" message to users, it should greet them with Good morning/afternoon/evening as appropriate - depending on the time of day.
It works absolutely fine in desktop and changed from afternoon to evening at 18.00 today, but it doesnt seem to be carrying over to App. Tried refresh obviously, not having it. Desktop says evening as its 18.30, App says Afternoon as I wrote it at 4pm.
What am i missing? Anything obvious? The measure itself seems fine. Every other data set and measure updates OK as far as I can see. Workspace has had both a scheduled and manual refresh in that time.
Here is the measure:
Solved! Go to Solution.
Hello.
To view the PBI Service you must match the server's time zone.
In my case I'm in Brazil, so I need to go back 3 hours in decimal in the measure 0.125
And it will look like this:
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
I understand that yes, it should.
Do a test using this model I made and see the result.
I think this way you can find the time difference
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
I will keep trying to work out the time difference but yes your measure works - thank you!
Hello.
To view the PBI Service you must match the server's time zone.
In my case I'm in Brazil, so I need to go back 3 hours in decimal in the measure 0.125
And it will look like this:
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
Thank you yes this makes sense and it does fix it in theory.
I am located in UTC region so I expected them to be the same as I understood service app worked off of UTC?
When I have tried changing the measure to random numbers it does change but I cannot work out which way it is going - its been a long day!
If I'm based in UTC should it not just marry up?
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |