Forum Discussion
Wrong Time after refreshing data file
Hi there,
I wanted to get a time stamp in my published reports to see the date and time when the online reports have been updated. Everything worked fine but when the dataset is updated via gateway it allways shows local tim minus 1hour.
It ested out some alternatives in the formula in power query but after publishing to Power BI online I allways get local time minus 1hour (Time zone is switzerland). Guess it must be some setting I am not aware of. Can u help me?
Hi Yarisch77,
If you're publishing to the cloud, the timezone will often default to the timezone of the server that the report is being hosted on. You can try to address this by changing the data format for your date field to one that doesn't start with an asterisk.Your other option is to query the local time from your own database rather than using DAX or Power Query to generate it. This should stick to the local datetime if you also set the date format to avoid using formats with the asterisk.
Cheers,
Sam
Blog: ApexInsights.net
Hi, Yarisch77
If you want to show the information in local timezone, you can create a Timezone table with timezone offset and then create a Measure to get the local current time for users viewing the report. For more details and how to create timezone table and measure, you can refer Show the refresh date\time in a Power BI report and dashboard and Showing Current Time and Latest Refresh Time at Local Timezones in the Power Bi Report.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Yarisch77,
If you're publishing to the cloud, the timezone will often default to the timezone of the server that the report is being hosted on. You can try to address this by changing the data format for your date field to one that doesn't start with an asterisk.Your other option is to query the local time from your own database rather than using DAX or Power Query to generate it. This should stick to the local datetime if you also set the date format to avoid using formats with the asterisk.
Cheers,
Sam
Blog: ApexInsights.net
Hi, Yarisch77
If you want to show the information in local timezone, you can create a Timezone table with timezone offset and then create a Measure to get the local current time for users viewing the report. For more details and how to create timezone table and measure, you can refer Show the refresh date\time in a Power BI report and dashboard and Showing Current Time and Latest Refresh Time at Local Timezones in the Power Bi Report.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.