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 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 publish it.
Once it publishes to the service I get this:
I tried changing the date time format in desktop and re-publishing but it does not seem to make any difference.
Changed date format again:
*Am I picking a bad date time format?
It is odd because in desktop it shows the filed thusly:
2/23/2018 8:16:47 AM
I don't really understand the disconnect.
How can I convert that to a timezone of my choosing?
Is there a better way to get the last refreshed date of the datasource in the SPO list query?
Thanks!
@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
Thanks, 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.
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.