search

Hugoberry / pbixray

PowerBI (pbix) file parser. Surfaces metadata and VertiPaq tables from PowerBI DataModel.
https://pbixray.streamlit.app/
MIT License
13 stars 4 forks source link

Table Update Time in PBIX data model #2

Closed Jooee1 closed 1 month ago

Jooee1 commented 1 month ago

I've been looking for this project for some time and this is fantastic! Now I also need to get the update time of each table, I looked at your code and found the [ModifiedTime] and [StructureModifiedTime] field in the table [table] in sqlite.

Data like this: Name ModifiedTime StructureModifiedTime
Fact_Table1 133661745237028401 133600448102961564
Fact_Table2 132936960559454745 132984804335114338
Fact_Table3 133583138169016579 133497641909798943

I tried to convert the [ModifiedTime] and [StructureModifiedTime] to the standard time format, and I found that it doesn't match the actual update time. And the Fact_Table3 is updated later than Fact_Table1, but Fact_Table1 has a larger number in the [ModifiedTime] field, which is weird. Do you know how to get the update time of the table please?

Hugoberry commented 1 month ago

This looks like a Windows FileTime format timestamp. Let me have a look at humanizing it.

A quick check on https://www.epochconverter.com/ldap gives me GMT: Tuesday, July 23, 2024 2:15:23 AM for 133661745237028401 entry.