Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Datetime Conversion on Browser showing same as original ...

I have a local function the blasts time back from UTC to local Indiana time.     When I publish it on the browser I am getting the exact same time for each field. Even though the desktop is s...
Data Protection
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ，

Are the fields Entered Date and Local Entered Date from the actual fields in the data source or are they generated later by adding custom column/calculated column? Are there any special settings for these two fields in Power BI Desktop? The question is why these two fields are displayed differently in  Power BI Desktop and Power BI Service?

Please review the following links and check whether they can give any clue and insights. Thank you.

Handling Different Time Zones in Power BI / Power Query

Difference DateTime between Desktop and Service

AVOIDING ISSUES WHEN GENERATING TIME/DATE IN POWER BI

Solving DAX Time Zone Issue in Power BI

Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The "Entered Date" is how I recieved it from the data source. I applied a custom function to it to generate "Local Entered Date". The first picture is how they are coming across on my Power BI Desktop, the 2nd picture is how they are coming across on the client's service in the browser.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    What custom function did you use to generate the Local Entered Date column? Could you please share with me a screenshot of the corresponding formula? Before share it, please mask it if it involve any sensitive info. What data source is the report connected to? What is the connection mode? Thank you.

    Best Regards