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.
I have just installed Power BI Report Server and am accessing a local SQL server for the data. One of the main reasons we invested in RS was hoping to get rid of the issues with everything using UTC instead of local time zone (EST). I published the first report to the RS yesterday and checked the report and at 8:00 the report reset as if it was a new day. Does anyone know why a local RS and data set would still be using UTC instead of the server time? Thanks.
Both the Report Server and the SQL Server are set to Eastern Time Zone... yet the report resets to the next day at 8:00PM as if it was midnight.
Hi, @Deronhess
Check the timezone of the computer that hosted SQL Server. For more, you can refer to this document.
Best.
Mark this post as a solution if this helps.
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 |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |