REAL TIME TILES AUTO CONVERT TIMESTAMP TO UTC

[ST19]

Dear community members, 

Need your kind assistance .

When I am trying to make line graph on Real time dashbaord.

Microsoft applies forced UTC interpretation on all datetime fields only in dashboard streaming tiles

• I push 2026‑02‑02 14:00 (SGT)
• Power BI assumes it is 2026‑02‑02 14:00 UTC
• Then Power BI converts it to your browser local zone (SGT) Becomes 22:00 on the tile.

I need to have same timestamp on line graph, that i am pushing using streaming type dataset. Is there a way to achieve that?

[v-nmadadi-msft]

Hi @ST19 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @ST19 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi @ST19  ,
Thanks for reaching out to the Microsoft Fabric Community forum.

Power BI Desktop runs on your local machine and therefore follows your system’s local time zone. As a result, timestamps, date values, and functions like TODAY() behave according to your local settings while you are developing the report.

Power BI Service, on the other hand, operates as a global cloud platform. To ensure consistency for users across different regions, it standardizes all date and time handling to UTC. You can think of UTC as the cloud’s universal reference time. When a report created in a local time zone is published to the Service, those timestamps are interpreted as UTC, which can cause the time values to appear shifted.

You can work around this by adding a calculated column directly to your table in the Power BI data model view. The logic is simple - you take the UTC date/time and add or subtract the time zone offset. Here's how to do it.

1. Navigate to the Data View: In Power BI Desktop, click on the "Data" icon on the far left pane to view your data table.

2. Create a New Column: From the "Table tools" or "Column tools" ribbon that appears, click "New column."
3. Enter the DAX Formula: In the formula bar at the top, you'll define your new column. The formula structure is similar to the Power Query method, but the syntax is different. To convert a [TimestampUTC] column to SGT (UTC+8), you would use:

TimestampPST = 'YourTableName'[TimestampUTC] + (8/24)

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[ST19]

Thank you for your response. I am able to maintain the same timestamp on the report page; however, the real-time dashboard tile applies an inbuilt format that automatically converts the timestamp to UTC, and I am unable to override this behavior. I would prefer not to pin visuals from the report page, as that introduces a noticeable lag. My requirement is to continue using the tiles directly.

[v-nmadadi-msft · Accepted solution]

Hi @ST19 ,

The only reliable workaround when continuing to use real-time tiles is to apply a time-zone offset before pushing the data. In other words, for your scenario instead of pushing 2026‑02‑02 14:00 (SGT) to your dashboard, try to push 2026‑02‑02 6:00 (SGT) this will be converted to  2026‑02‑02 14:00 (SGT) in the dashboard achieving your desired value.

Thank you