Forum Discussion
Semantic Model Refresh History For Particular Tables
Hello everyone, I want to create a table in my workhouse where I can store my refresh history of each tables within my semantic model. I have been searching the ways, but I can only find that it is possible to track on the refresh history of all semantic model not for individual tables. Does someone have a suggestion for retrieving the refresh history of tables in my semantic model? Especially a solution for notebook is something, I am looking for.
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
13 Replies
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,
You shoul dbe able to do this with XMLA endpoints and Semantic Link.
See this blog post:
https://data-marc.com/2024/05/28/dynamically-refreshing-historical-partitions-in-power-bi-incremental-refresh-semantic-models-using-fabric-semantic-link/If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi Deagle,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to tayloramy, for his inputs on this thread.
I understand that you want to track the refresh history for individual tables in your semantic model, not just the whole dataset. Currently, Fabric natively tracks refresh history at the dataset level, so there isn’t a built-in way to see table-level refresh logs directly.
However, you can achieve this using a Fabric Notebook along with the Semantic Link library. Below is the approach:Set up a notebook and install the semantic-link library. Connect to your workspace and dataset in the notebook. Retrieve all refresh requests for that dataset. Filter the requests by table name to get table-specific refresh history. Store the results in a Pandas DataFrame or in a database for easy tracking and analysis. You can even schedule this notebook to run regularly, so your table-level refresh history is always up to date.
For reference, here are some useful links from Microsoft:
1. https://learn.microsoft.com/en-us/fabric/data-factory/semantic-model-refresh-activity
2. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group
3. https://learn.microsoft.com/en-us/python/api/semantic-link/overview-semantic-link?view=semantic-link-python
4. https://learn.microsoft.com/en-us/fabric/data-science/semantic-link-overviewHope this clears it up. 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.
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
