Get refresh time from Power BI Service into Desktop

[taariq_gcx]

Hi, is there a way to get column 'Refreshed' from Power BI Service into Power BI desktop, attempting to create a dashboard where all reports and datasets refresh times are listed.

[v-xulin-mstf]

Hi @taariq_gcx

Maybe you can get refresh history of workspace first, and then filter in the exported data to get the last refresh time.

Please refer to the Powershell script I provided in this post.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[taariq_gcx]

How do I use the power shell script within Power BI to get my result?

[v-xulin-mstf]

Hi @taariq_gcx,

You need to run this script in powershell.

About how to apply Powershell script with power bi, please refer:

https://community.powerbi.com/t5/Community-Blog/Get-dataset-list-with-PowerShell/ba-p/1604912

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@taariq_gcx , In desktop we add date in power query to get the last refreshed date

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

[taariq_gcx]

I want a list of last refresh dates in Power BI Desktop for all reports and datasets, not just for the one you working on