Forum Discussion

gellmann94's avatar
gellmann94
Frequent Visitor
6 years ago
Solved

Excel Online Data source with calculated columns

Hello, I have the following scenario. My data source is an exce spreadsheet online (I am using it online so that I don't need a gateway). Some of columns have formulas to give value to the cel...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

gellmann94's avatar
gellmann94
Frequent Visitor
6 years ago

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.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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