How do you get a REFRESH DATE in your Power BI report???

[@yornav]

Yep, doing this as a common practice in my reports for the same reason as you describe. To show what the last refresh time was to the end user, but also to make it easier to detect refresh failures.

[@ChrisWagnerDatagod]

Love this! Truly a best practice.

[@GuyInACube]

Agreed! So many people don't have something like this though. :(

[@ChrisWagnerDatagod]

@@GuyInACube Say it ain't So!!!

[@DitchChickenAdventures]

You guys are amazing. Just learning Power BI and you have made life so much better

[@mikeycbd]

Thank you from Melbourne Au. Only been using PowerBI about a year and believe I need to show my audience when the data was refreshed. Very easy to follow, thanks again. Mikey Mike

[@tjarbeaux8662]

Needed a quick answer and you delivered! Exactly, what i needed.

[@MonkeyWoodworks]

Hey Guy in a Cube. You have some great videos! I am just getting my feet wet in PowerBI and these are super useful. On this particular topic, this works great only when you have a published page, the published page uses a completely different timezone than my desktop apps does. Is there a way to FORCE a timezone in that date capture so both the desktop app and the published page keep the same timezone?

[@paulwhite3336]

So good when you can find the exact answer to your precise question, thanks!

[@TM-nj6vd]

This was a great video and helped me a lot. I know nothing about Power Bi but need to teach myself a few things for work tasks. Tried to use Copilot/AI to learn how to do a refresh but couldn’t get it to do what I wanted. Your video solved it quickly and I feel like I understand Power BI just a tiny bit better

[@felipescherer6678]

Very good to have this KPI to show last refresh time especially if the users access the Reports in PowerBI services web page

[@KasiaWichrowska93]

Great video, so simple yet so powerful! Thanks for sharing!

[@NathanProctor-pj1wz]

Simple and direct, this is why you're the best. Thank you

[@twitchingmind]

This saved my life thank you!

[@Preteshd]

Thank you, just used this in my report. Very useful.

[@leighnb1984]

Is it possible to get the next schedule refresh date for a report based on the schedule refresh times defined in the powerbi service?

[@BobsBitsOutdoors]

Thanks, you've saved me a heap of research to get this working.

[@brycebarth]

I prefer to have the date shown when my data was last modified. Having a refresh date doesn't tell me much if the data driving it hasn't changed. So, in the query editor, we bring in the folder where the data source file is stored, filter for the correct file, then use the date modified.

[@brigittahegarini7162]

Oo0

[@lancecassemis6806]

Thanks so much. I would say they only thing to improve on would be to change the category label to larger text size, rename table to "refreshed date" and change field from last to first such that it reads " Last Refreshed Date"

[@boydbarnwell138]

Followed these instruction exactly and it worked great. What about correcting for time zone? How do I modify the invoked function so my app agrees with the refresh schedule I set in the app.

[@alfonsocoffman788]

Excellent, so much better than the online solution that always crashes!

[@jamesparker2511]

This was awesome. Thank you so much for this video.

[@realercheng]

This is great, short and to the point, Thanks.

[@priscillabatterie347]

Thank you so much. Your videos are extremely helpful and straight to the point.

[@megcrossland]

Love it. I have learnt everything I know from you guys. Thanks a bunch.

[@HammadKhan-lu3yb]

yeah i think this is the better solution to find the refresh issue. Appreciated

[@kristianjohannesen3768]

So simple - so helpful. Great!

[@flaviooliveira3492]

Congrats, man, exactly I was needing!

[@RicardoMurgas]

This is amazing! You just saved me. Thank you very much.

[@dominiquederoeck8100]

The KISS method: Keep It Simple and Straight. Thanx!

[@NabranAboubacar]

Nice tips, easy to apply. Thx

[@Anthony_Lecoq]

That was a great tips, thanks Adam

[@rayanedaluz303]

Loved the video!!!!! Thanks a lot

[@advent7324]

Nice video. Keep up the great work guys

[@SolitudeMovement]

Thank you for this!

[@estelalarios]

very useful, thanks a lot for this video

[@annalisekerr7796]

Simple and very useful, thank you

[@fredatang4058]

so helpful, thank you so much.

[@heatherr5191]

My approach (working with a database of sales data that refreshes overnight) is to instead report the last invoice date from my report. But I will definitely keep this in mind for other applications.

[@GuyInACube]

Yup, that is another great way to do it. Depends on what you want to see. When the model was actually last refreshed, regardless of the data inside, or the last current record you have within the data. Or, maybe both :)

[@sujitthakur4172]

You guys are the best !!!

[@GuyInACube]

Appreciate that! 👊

[@cyberblitz]

Humm, I tried this but as soon as I put my dashboard on the Power Bi Server, it used the date the server was using, which is in a different country. How would you approach this situation?

[@tausifsheikh1722]

Have you got the solution for this?

[@HebertAG]

I went with UTC time and then add or substract your time zone

[@stefankal77]

great and easy ! thanks

[@GuyInACube]

BAM! Thanks for watching! 👊

[@payaljain5343]

So amazing!!

[@lucianoelias8961]

You guys rock!

[@ricardoabella867]

Adam, simple and useful thank you so much

[@JoseSalazar-jm8os]

*Smashing the Like button* Thanks for this!

[@GuyInACube]

YES! Thank you 🙏👊

[@garciarogerio6327]

Nice one. Thank you

[@johnsonfbrian]

This was a Very useful feature.

[@proteuswave]

Nice! Thank you.

[@kim1217]

Easy-peasy, lemon-squeezy 🤓 simple, bit very useful!

[@GuyInACube]

Agreed! 👊

[@markknowles1936]

Very useful, thanks :)

[@shashwattiwari1991]

Very nice video thanks !!!

[@cmarinoleon]

Thanks again !!

[@nattawut_chatwiriyacharoen]

I love this video! Many thanks

[@vannitecmediastudio5860]

Awesome, perfect and thanks for the video.

[@shauryamittal3041]

Hi @guyinacube, I use a calculated col in my report just create a col and enter UTCNow() function to get the date time in utc, now to show the time zone i just concatenate this function with " UTC" string and now they know when their data was last refreshed.

[@GuyInACube]

That is another way to do it. I usually try and push things as far back as I can. But, assuming it is by itself, that may not have a lot of overhead from a calculated column perspective.

[@scottschuler2234]

@@GuyInACube The issue with that approach happens in the service when an end user hits the refresh button and the DAX calculates but the data isn't actually refreshed. Power Query is the only way outside the metadata in the new app experience

[@DiegoAndresDazaDavalos]

This was very helpful

[@stephenc7077]

This is great, except when you have people from across various different time zones looking at a report. The "Local Now" of the server (in our case) is UTC. How do I get that value to translate to the logged in user's time. I'm guessing it's not possible given that when I put a simple measure of SimpleTime=NOW() and I display that as a card, it's coming up as the server's local time. Whereas when I do this on my desktop, the NOW() shows as the local time and UTCNOW() shows the UTC (I know, under redundant see redundant). I have users in all 4 US timezones so I really can't do an offset at this point.

[@JeremyCooperIsAwesomeSauce]

Standing by for an answer on this one. Same issue here.

[@dougnichy7018]

@@JeremyCooperIsAwesomeSauce Ever find an answer to this?

[@holt59454]

@@dougnichy7018 same issue here, anyone resolved this ?

[@arunmarkrajan6626]

Thank You Sir

[@joaoluismartins]

Hey Guys, For those who are struggling with the UTC time of the Refresh inside the Service, a good approach is to use the code below: Source = DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),-3,0), where "-3" is the difference between your timezone and UTC timezone.

[@nathannoel9837]

Thank you. Made things a lot easier on me. :)

[@mikegodbout6845]

This step should be included in the video. This was key!

[@williamrodriguez2694]

I don't think this accounts for daylightsaving (in the US)

[@ExcelWithChris]

If you do this on the local machine, updated and upload I assume it will work. but will it still work once you publish and updates run on the service and not from you local machine?

[@sonal008]

It doesn't work on Power BI service

[@rajanair79]

This was very helpful. Thank you for posting this :)

[@raymondamato812]

One thing that would be cool is to see how to create a timestamp in your report that shows the last time a Dataflow/set has refreshed, not necessarily the report itself

[@kingsfordgokah6240]

Great to learn this trick

[@arklur3193]

If I start the refresh at 10:00:00 and the refresh ends at 11:00:00, the table will have a close value to 10, right? Something like 10:00:02 or so. How could I achieve to get the end time, or something close to it?

[@mcnater]

My organization just asked me this exact question. If the report runs long...what is the ACTUAL time that shows?

[@StephenEngine]

Depending on how exact users want to see the last refresh date/time, maybe it's worth finding the average time of a refresh and then add that time average to the current date/time M language function. Just a thought and may not work but it's an option.

[@sebastienderivaux386]

Maybe you can make the time query depend on your slow query.

[@barca06]

thank you!

[@M_AGraphics777]

Thank you 😊

[@bakalula]

Thanks, just fixed a clients request on a Saturday lol :D

[@brigadeanalytics3737]

What about displaying the NEXT scheduled refresh date. This information is available in the Power BI Service when you have Scheduled Refresh times selected. I'm just wondering if you can display something similar in Power BI Desktop.

[@shoaibrehman9988]

Cool stuff, i was looking vba coding old school method. Gr8 Video Make life easy Thanks

[@LuckVagner]

Awesome, how do I get the refresh date for each table ?

[@minathanh7072]

That is an amazing video!

[@gerrythomas6297]

you are the best!!

[@Ta-mq3wb]

Great Video as always !! I am able to apply the query to my report but when I upload online The power bi app shows 03/14/2022 5.53.ss pm(future time) and only when its updated to app whereas on Desktop and in the online workspace shows correct time.

[@Adi_7004]

Thanks for the video. It is pretty much a common requirement to display the latest refresh time . Do we need to Add/Subtract the time from UTC time to display MY local timestamp in Power BI service? Is there any better approach to achieve this?

[@stick7646]

Try DateTimeZone.FixedLocalNow()

[@oozmeister1627]

Really simple and useful video thanks. Quick question: how do I remove the seconds??? I've searched for ages and can't find an answer!

[@kimgraf4085]

What do I think? I think you guys are awesome!!!!

[@abdullahejaz226]

Really helpful... Thank you (Y)

[@ncbshiva]

If i publish this to the service, then i get the Datetime of the refresh in UTC time. How can i get the last datetime refresh of my time zone ?

[@Adi_7004]

Presuming that you are looking for IST. Adding 5 n half hours to date.localnow() should do the job if you are not worried much about the time displayed in PBI desktop. But I believe a better approach should exist

[@ZigBaird]

Our company has locations all over the US so I just report everything in EST and instead of using Adam's approach, I just create a datasource that queries the GETDATE() of our SQL server and return that in our model . Not sure of your datasource but that might help you or others.

[@joaoluismartins]

Hey Shiva, you can use the following code: Source = DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),-3,0), where "-3" is the difference between your timezone and UTC timezone.

[@ncbshiva]

@@joaoluismartins Thanks , but if my time zone follows Day Light Saving then this solution might not work.

[@ncbshiva]

@@Adi_7004 Thanks , but if my time zone follows Day Light Saving then this solution might not work.

[@janakiramn6818]

Is it work when I refresh from the power bi service after publish ? Share your thought.

[@acaguade]

Now a tricky one: can you suggest how to achieve same result for DirectLake based semantic model?

[@ramendrakumar2834]

Hi Adam, It only shows UTC date time in power bi service. Pls suggest how to change time zone for IST and other time zones

[@ducminh7568]

the only way I found it extract from the time website.

[@danielsiffredi8403]

@@ducminh7568 can you please share how do you do that? I'm still stuck with UTC date time and I don't like it. thanks!

[@ducminh7568]

@@danielsiffredi8403 nah they way i did is extract data via website option in Power Bị and find any time website on the internet

[@jlponente]

Great. thanks !

[@richarddavison8838]

I generally add a query to the model that gets the date from the database and then display on report with the Timezone of the Server noted so folks know. Interesting thoughts on how to convert this to local time for the viewer that I will now have to consider.

[@guillaumedoguet5367]

Hey, thanks for the tip. One problem of publishing this to Power BI Online is that Power BI Online only works on coordinated universal time (UTC). It will change your local time zone whatever you do. So for Europeans with summer/winter time zone it is a pain to work with.

[@srdjandrljaca7]

kzbin.info/www/bejne/roDNaH6EpsqSmas

[@srinivaspappu]

Any trick to overcome this ?

[@NdySerdu]

Thank you so much for all your videos.. Simple and very usefull ! You're the man ! :-)

[@gerrieolivier5099]

Great, to the point

[@waltontan7840]

Hi, will this break a direct query type report? As in make it no longer direct querying?

[@TheLampattheDoor]

Very useful. Thanks. The only gotcha I can think of is that this is the date/time of the data refresh from the source. If the source is pulled from another source (which mine is) then that refresh date won't be reflected. My example is that my data is in a google sheet. Unfortunately I don't know of a way to read google sheets from power bi so I need to download to an excel sheet and then pull that into pbi.

Thank you for the excellent content. I have a doubt. How could I get a refresh date from a specific data table?

[@zahir4215]

@Guyinacube HEY! it's amazing work but how do we get only 2 tables to auto-refresh only?

[@tesselma]

Great stuff. Thanks

[@plupppp]

Does this work with schedule refresh?

[@rolaxx]

Read my mind sir! Thanks!!!

[@reileybergin10]

I had the same problem many others have mentioned which is that the time displayed in Power BI Service is in UTC. I tried the other methods that were recommend by others like the using DateTimeZone.FixedUtcNow() as datetimezone, however this did not work once a manually refresh was trigged within Power BI Service. As a workaround the following code worked for me: Date_Time_Local = // Grab date value from column VAR refresh_date = MAX(DataRefreshTime[Date]) // Grab time value from column and subtract by 4 hours VAR refresh_time = MAX(DataRefreshTime[Time]) - 4/24 // Display the date and time VAR result = refresh_date&" "& refresh_time return result

[@abhishekpednekar7364]

That's really great.. but when I publish this into Power bi service, it shows UTC time rather any specific time zone.. how to resolve this, please help.. Thanks..

[@andres777video]

For Auditing, Is there a way to obtain the Reports (PBIX or RDL) Last Modified Date ? Or Last Published Date to the service ? Not in the API, and Purview Hub Insights used to have it in the Inventory section, but no longer there... Also don't want to turn on Auditing logs Details in Production, for persormance reasons Thanks!

[@SivaramKumar-i4b]

is there any workaround for refreshed time in DirectQuery storage mode

[@orangemeca1407]

Hello, Can you tell me how to change the time format, so as not to have the seconds please

[@TumiSelepe]

Do you like this data refresh to the calendar 📅 table?

[@MnisKmr]

What if i wanted the different time zone date time refresh?

[@bcassilhas]

Can we have a query that only updates the date if something on model has changed (table settings or database update)??