Forum Discussion
Semantic Model Refresh History For Particular Tables
Hi Deagle ,
Power BI doesn't natively track the last transformation time for each individual table in a semantic model.
However, you can manually add a
timestamp during the final transformation step in Power Query. For each table, you can either add a column using DateTime. LocalNow() to mark when the data was loaded, or create a one-row summary table that logs the refresh time. This way, you can display the last transformation timestamp per table directly in your report.
Thanks,
Sai Teja
Hi Deagle,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.
Thank you.
I read your message and attached texts. however they do not provide the refresh history of the individual tables within the semantic model. I am still missing that part, but thatnk you for your help
Hi Deagle,
Thank you for getting back and for clarifying that. I completely understand your point.
You are correct that the current APIs and Semantic Link libraries do not yet expose table-level refresh history directly from the semantic model.
Currently, Fabric only logs refresh activity at the model (dataset) level, so there is no native way to extract individual table refresh timestamps or statuses from the semantic model itself. As a workaround, you could consider the following approaches depending on your setup:
Custom Logging During Notebook-Based Refreshes: If your tables are being refreshed or loaded through a Fabric Notebook or Data Pipeline, you can manually log the refresh completion status for each table (e.g., by writing to a “Refresh History” table). This way, you can simulate a table-level refresh log until native tracking becomes available.
Please refer these links:
1. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history
2. https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models
3. https://learn.microsoft.com/en-us/fabric/data-factory/semantic-model-refresh-activityHope this helps. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
Hi Deagle,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi Deagle,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.