Forum Discussion
OneWithQuestion
Post Prodigy
Post ProdigyDateTime changes to GMT when report published? *How to get last refreshed date?
I have a dataset that I created in PBI desktop which comes from an SPO list. I added a custom column with LastRefreshDateTime = NOW() When I view it in desktop it works fine of course, then I...
OneWithQuestion In the service if you click on the "?" in the header you can select "About Power BI" this will show you in the pop up where your data is stored. I believe this will dictate the timezone for your calculation.
Check out Reza Rad's blog on this, he outlines the issue and solutions. - http://radacad.com/solving-dax-time-zone-issue-in-power-bi
OneWithQuestionPost Prodigy
Post ProdigyThanks, I see that:
My report shows: 06:20:40 GMT -0600 (Central Standard Time)
My data set shows last refresh of: 2/26/2018 12:29:55 AM
My data is stored in North Central US (Illinois)
I'll check out that link to the blog.