cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Latest datemodified column in Direct query

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Latest datemodified column in Direct query

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.

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Latest datemodified column in Direct query

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.

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors