Forum Discussion

Deagle's avatar
Deagle
Frequent Visitor
10 months ago
Solved

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 p...
admin
data hub
one lake
workspaces
  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    10 months ago

    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 

Deagle's avatar
Deagle
Frequent Visitor
10 months ago

Hi tayloramy, I read the article that you sent. It is kind of usage of semantic link for fabric in notebook. He used this to dynamically refresh his semantic model and see the requests, however it does not provide the refresh history of the individual tables within the semantic model.