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 

SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
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