topic Different time in online report vs. desktop / last refresh time and created time in Report Server

Different time in online report vs. desktop / last refresh time and created time

MarcDT21 — Tue, 17 Aug 2021 19:04:42 GMT

Hey there

I think I watched almost every tutorial video to this topic but I'm obviously missing something. I have problem with the local time showing correctly in the online reports. In the desktop report every thing is fine and correct according to my data source sharepoint - but online all the times are 2 hours behind, despite to formatting them to local zone times.

As for the formating of the columns e.g. the last data refreshing time in my desktop report:

- new Query with custom column

- used formula: DateTimeZone.LocalNow()

- data type: Date/Time/Timezone

I'd be verry thankful if anyone could tell me what I am doing wrong.

Re: Different time in online report vs. desktop / last refresh time and created time

Greg_Deckler — Tue, 17 Aug 2021 19:16:12 GMT

MarcDT21 Where are you located versus where is your tenant located?

Re: Different time in online report vs. desktop / last refresh time and created time

MarcDT21 — Wed, 18 Aug 2021 18:37:46 GMT

Greg_Deckler I'm in switzerland an my tenant as well (UTC+2)...
for the refresh time I figured it out how to do it according to https://radacad.com/solving-dax-time-zone-issue-in-power-bi method 3.

but for the created time (timestamp from sharepoint) I still have the problem.