Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a Power BI account in IST timezone, the same account have access to CRM. So the date field value in CRM and Power BI report is same (Importing data). The same record is accessed from another account from CST timezone, so there in CRM the date value is one day less but the Power BI report is deployed in services and added in CRM using the first account (IST timezone account). Here the date is not converting to CST timezone when CST user access the report.
Please help to convert the date value based on local timezone (if IST account is accessed the date value should display IST timezone and if CST account is accessed the date should display CST timezone value)
Thanks,
Gokul
Have you looked at this article from Reza?
https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-...
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |