cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chanleakna123 Post Prodigy
Post Prodigy

How to Calculate "Schedule Refresh" on PBI Desktop & PBI Service

hi , how to calculate Refresh Update Schedule display on PBI Desktop ? 
my purpose is to let my user see the report of the latest update on screen , then they know day and time of the latest update. 
My location is in Cambodia. Can anyone assist me to acheive this ? 

Thx with REgards, 

2 REPLIES 2
v-piga-msft Resident Rockstar
Resident Rockstar

Re: How to Calculate "Schedule Refresh" on PBI Desktop & PBI Service

Hi @Chanleakna123 ,

 

Do you want to show the latest update time for the report in Power BI Desktop?

 

If it is, you could add a custom column to data model using Power Query and then formatted the column as Date Time: Refresh date/time =DateTime.LocalNow()

 

In addition, you could have a reference of this blog.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-piga-msft Resident Rockstar
Resident Rockstar

Re: How to Calculate "Schedule Refresh" on PBI Desktop & PBI Service

Hi @Chanleakna123 ,

Have you saved your problem?

If you have saved your problem, could you please share the solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors