Latest datemodified column in Direct query

[Apsawhney]

Hi,

I have a direct query report I am making and the tables I have used has a datemodified column in them which is configured using teh getdate function in SQL. 

"DateModified TIMESTAMP NOT NULL DEFAULT (GETDATE())"

So now when ever data is pushed into these tables the datemodified picks the current system time to identified the latest record. 

But the problem I am facing is that the DB is in UTC, my report needs to be in UTC+2 and when I publish this report to the powerbi service it coverts this datetime to UTC-8. Is there a way to get the last update column in UTC+2. 

[V-lianl-msft · Accepted solution]

Hi @Apsawhney .

We can't set the time zone on Power BI Service. To get the correct local time, we can add time difference in your DAX formula, or use Power Query to get the local time zone datetime. For more details, please refer to this blog.

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.