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.
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.
Solved! Go to Solution.
Now we just need to hover on the table name in the model view:
@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/
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! 😀
@lkalawski wrote: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?
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! 😀
@lkalawski wrote: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.
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.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |