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

[MarcDT21]

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. 

[Greg_Deckler]

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

[MarcDT21 · Accepted solution]

@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.