PowerBI web not showing local time

[Anonymous]

Hi,

I have a report with a Date/Time TimeZone field set to En-AU. When I refresh data on PowerBI Desktop I get the correct local time but when a scheduled refresh takes place, the report shows UTC time instead of local.  

Is there any way that I can fix this? 

Thanks

[BhaveshPatel]

You can create a blank query and write below syntax to get the Brisbane time. This will not change with query refresh.

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),11))

[Anonymous]

Thanks @BhaveshPatel . Your formula does result in local time. But what I want to do is to convert an exisiting Date/time field to local time. So I added a calculated column using DateTime.AddZone([Date]11)) formula and it still shows UTC time instead of local 😞

Any thoughts?

Thanks

[v-haibl-msft]

@Anonymous

Please try the DAX formula mentioned in this thread.

Best Regards,

Herbert

[Anonymous]

@v-haibl-msft,

Thanks for your comment. The problem with using this formula is it subtract 8 hours even when data is refreshed locally which ultimately result in a wrong time.

As I've mentioned in my first comment, I only get a faulty time when data is refreshed on the cloud and not on PowerBI desktop. 

[Anonymous]

Hi @v-haibl-msft,

Thanks for your reply. I am on Windows 10 1607 and has the latest PowerApps installed.

I do not have the error message that I was getting earlier but now the apps won’t open in edit mode and get stuck at the loading screen (Please see the screenshot below)

I tried in both Edge and Chrome and run into the same issue. And since I cannot open the app either on Studio or Web in edit mode I am stuck on preview environment and cannot migrate any of my apps.

I would appreciate if you could help fix this issue. Thanks

Regards,

Anton

[Anonymous]

I have the same issue with local time. The Desktop report date is correct but when published into PBI, the date is converted to local date where PBI service database is located.  I have contacted Microsoft on Monday, but until today i did not get any reply..