Forum Discussion
Excel Online Data source with calculated columns
Hi gellmann94 ,
AFAIK, power bi service will convert DateTime values to UTC format instead keep the original format(local timezone). I think your scenario may be related to DateTime UTC conversion, you can check the following blog to know more about this:
Convert UTC to Local Time with Daylight Savings Support in Power BI
Regards,Xiaoxin Sheng
Hi gellmann94 ,
As the document said, it seems like related to your workbook and refresh settings, can you please share more about your refresh settings?
How to Get Your Question Answered Quickly
DAX TODAY function
Regards,
Xiaoxin Sheng
I would like to add some pictures to my words, to clarify what I mean:
In the first picture you can see the offers that are included in the data model.
Please note that there aren't any offers whose data is later than 8/12/2019 (8th of December)
The second picture shows what happens if I apply the same selection criteria to the data on the excel online data source.
As you can see there are plenty offers with date greater than 8/12/2019.
Finally, please note that I manually refreshed the dataset before taking these screenshots and nothing changed.
Hi gellmann94 ,
AFAIK, power bi service will convert DateTime values to UTC format instead keep the original format(local timezone). I think your scenario may be related to DateTime UTC conversion, you can check the following blog to know more about this:
Convert UTC to Local Time with Daylight Savings Support in Power BI
Regards,Xiaoxin Sheng