2

We have a web application in which we have embedded Power BI reports.

We are using Direct Query mode for connecting to AzureSql DataBase.

Our Database has DateTime values stored in UTC format. We want users to see these data values in their local time zone(i.e. if users access reports from EST time zone they should be able to see reports according to that time zone and so on). For that we want to pass date as parameters in filters so that we can filter out the content based on current Time zone.

Is this possible?

Please help.

Thanks in advance

Aman Garg
  • 21
  • 3
  • This is extremely complicated issue, and has nothing to do with filtering at all. Think for DST for example. You can get some ideas how to solve it from Reza Rad's [Solving DAX Time Zone Issue in Power BI](https://radacad.com/solving-dax-time-zone-issue-in-power-bi) – Andrey Nikolov Oct 11 '19 at 09:53

1 Answers1

2

Yes, it can be done as follows.

  1. Create a report level filter for the Time in your report.
  2. Get the UTC time from the client side where the report is being embedded.
  3. Pass the fetched time as the filter to the Power BI embed report object during Phase Loading.
Ankit Kesharwani
  • 96
  • 3