Where can I see the last table refresh date?

[Zyg_D]

As simple as that, I cannot find table's last refresh date. I don't want it on any report. I just want to inspect it for myself. 

[Zyg_D · Accepted solution]

Now we just need to hover on the table name in the model view: 

 

[amitchandak]

@Zyg_D , refer

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

https://www.youtube.com/watch?v=oN6mOmEruOQ

https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

[lkalawski]

@Zyg_D

If you chose Import mode:
- You can check the Refresh dataset in Power BI Service, Go to the dataset settings and choose schedule refresh. In this place you can find History of refreshing.

If you chose Live connection and you have access to the model:
- You can connect to the model via SSMS, then right click on the selected table and select Partitions. There is information about the last refresh of a given table.

If you only have access to the report, unfortunately, without an additional column in the table that will have such information, you will not be able to check it. You can only check the refresh of the entire dataset.

_______________
If I helped, please accept the solution and give kudos! 😀

[Zyg_D]

---

@lkalawski wrote:

@Zyg_D

If you chose Import mode:
- You can check the Refresh dataset in Power BI Service, Go to the dataset settings and choose schedule refresh. In this place you can find History of refreshing.

If you chose Live connection and you have access to the model:
- You can connect to the model via SSMS, then right click on the selected table and select Partitions. There is information about the last refresh of a given table.

---

Does this apply to the Desktop version of Power BI? 

[lkalawski]

@Zyg_D

Unfortunately, in Power BI Dekstop you can't just check the last refresh of the table in normal way. 
You need to create an additional column that will contain the refresh information.
Check the link sent by @amitchandak , it shows how to add such a field in Power Query. You can do this for each table and after refreshing the data, the date will update.

_______________
If I helped, please accept the solution and give kudos! 😀

[Zyg_D]

---

@lkalawski wrote:

@Zyg_D

Unfortunately, in Power BI Dekstop you can't just check the last refresh of the table in normal way. 
You need to create an additional column that will contain the refresh information.
Check the link sent by @amitchandak , it shows how to add such a field in Power Query. You can do this for each table and after refreshing the data, the date will update.

---

Thank you for writing in human language that it is impossible, and workarounds will be needed. The other answer does not explicitly tell it, which is why I accepted your answer.