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

Hello Xiaoxin, thank you for your answer.

I am not sure if I made it clear enough in my original post, but all the time logic is implemented in the online excel data source, therefore I don't understand why you linked the article about the TODAY() function in DAX.

Anyway, I am glad to provide the details about my refresh setting, if you can clarify what those are.

Do you mean how the refresh is scheduled for the Power BI Data Set in the Service?
In this case, the data is refreshed daily at midnight.