Forum Discussion
DAX time intelligence question
Hi, I have been troubled by this problem for a long time. So my data source is a data table from a MSSQL server and my data is updated in the real time. Now I want to get my today's sale...
- Hi there
All the Power BI Servers have their dates set to UTC.
In my blog post below I detail why this is and how to make the required changes to your dataset
https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/
nandic
Resident Rockstar
Resident RockstarAnonymous ,
Is there an option to update time zone on Power BI Service (so that it is compatible with your time zone on dekstop version)?
Example: if you use Office365 there is option to change time zone. Office365 settings will have impact on Power BI Service as well.