cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sakshi Regular Visitor
Regular Visitor

Fetch local timezone of webapp in Power BI report having live connection to Azure Analysis Services

We have a Power BI report embedded in web-application having a live connection with Azure Analysis Services.

 

This report displays time intervals according to UTC as the data stored in Azure analysis services is in UTC. We want to display this interval time slots in local timezone in which the web application is accessed.

 

I tried using Dax NOW() and UTCNOW() function but these function if created on Azure Analysis services result in UTC time to be displayed on Power BI report. 

 

Any help will be greatly appreciated to get local time on Power BI report considering the DAX calculations are done on Azure analysis server model and Power Query M could not be used in this scenario.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors