Fabric time time-travel error "A non-versionable data source was specified in the time travel query"

[Kazanskyi]

I am tryng to run a  SQL query to get table's previous version data as in the instruction:

SELECT *

FROM [dbo].[dim_item]

OPTION (FOR TIMESTAMP AS OF '2024-06-18T17:37:26Z')

And I get the error: 

A non-versionable data source was specified in the time travel query.

When I check the datalake I see many versions of the table stored.

When I'm querying with Spark through versioning, it works as well.

df = spark.sql("SELECT * FROM Invoice_and_Order.DIM_Item LIMIT 2", version =5)

Do you know what I am doing wrong?

[foodd]

@Kazanskyi Time Travel is in Preview, have you looked at the documentation.    I believe that the 

CAT Team over on the Fabric Subreddit should see this question quite quickly if you want to  drop of the question over there as well.  

https://www.reddit.com/r/MicrosoftFabric/

Alex Powers (u/itsnotaboutthecell) is the Moderator over there and he loves all things Fabric.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.