Calculated date wrong on Power BI Server
I have a "Last Refresh Date" field in my report that is populated from a manual query: let Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}}) in Source When I run it locally in PowerBI Desktop it works fine. When I publish it to the on-premises report server, the date is wrong. I have confirmed the report regional settings are set to Australia. I have confirmed the report and database servers regional settings are set to Australia. I have confirmed that the date/time on the servers are correct. This report is scheduled to run every hour. When I look at the schedule in the "Manage" screen, the date and time are showing correctly: Report details: Schedule details: Both screenshots were taken within 1 minute of each other, and I refreshed the report to make sure it was displaying the current details. I am running the October version of the Power BI Server. Anyone have any ideas?
last refresh date/time for users location
Hi, I find it very difficult to make a last refresh date/time based on the users locations. I have users logging in from all around the globe and I want to show them their date/time. Users logging in from: - Europe - Dubai - Singapore - Jakarta - Perth, Austrlia - Vancouver, Canada - Tanzania Does someone knows a solution to for them all based on their date/timezone when report has been last refrehed?
