Forum Discussion
Relative date filter showing blank value when report is uploaded to service
Hye analytical_mind ,
That might be it....the LocalNow might be using the UTC Service time? Perhaps use a DAX formula or use Query Editor to set the time to a specific time zone?
Super UserHi analytical_mind ,
Following your Relative Date train of thought....the Service is set to use the UTC time zone. That may be just different enough from you to be causing your issues. The best way around this is some DAX to get you to the right date/time that you need.
Here are some of the links that might be helpful:
Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com)
Set local time zone Power BI Service - Microsoft Power BI Community
Solved: TimeZone - Microsoft Power BI Community
Solving DAX Time Zone Issue in Power BI - RADACAD
Hi collinq , thanks for your reply.
I wonder if it might also be related to how I've built my dim date table. I have a query named 'Today' which reads:
= DateTime.Date(DateTime.LocalNow())
I use this query as an input for my dim date table:
= List.Dates(Today, 1095, #duration(1, 0, 0, 0))
then I transform it to a table. This means that everytime I click the refresh button, it'll load 1095 days from the day I clicked.
- collinq
Hye analytical_mind ,
That might be it....the LocalNow might be using the UTC Service time? Perhaps use a DAX formula or use Query Editor to set the time to a specific time zone?
I found a workaround setting up daily refreshes (in pbi service). It seems to be working now.
