Forum Discussion
Version AsOf in semantic model.
EdvanceIQ_Chris , I doubt we have that available in the Semantic Model Yet.
We have a Power Query function get DeltaLake.Table M (https://youtu.be/D_8ldwRTkyg), but that is also static to the data load
Snapshot is one way, but that will have too much data.
Community SupportHi EdvanceIQ_Chris,
Thank you amitchandak, for your insights.
DirectLake reads the Delta table only at the most recent framed state, so time-travel queries aren’t available in this mode. The Warehouse time-travel documentation also notes that time travel is not available on the Lakehouse SQL analytics endpoint, and that Power BI DirectQuery cannot use time-travel syntax.
Time Travel - Microsoft Fabric | Microsoft Learn
Direct Lake overview - Microsoft Fabric | Microsoft Learn
Thank you.
Thanks for the comment but it is not particularly helpful. I can see that it is not available at the moment, so how can I get it to work? What is the solution? Or, is there a roadmap where this functionality is due to be added. I want to allow users to select a date in the reports and for the data for those reports to be served up as of the version that existed for all the tables at the required date. With the functionality available in the underlying tables, it seams crazy that there is no way for a user to be able to select the date/version and use the data from that point.
- v-saisrao-msft
Hi EdvanceIQ_Chris,
At the moment, DirectLake does not have built-in support for user-initiated time-travel. You may want to submit a feature request on the Fabric Ideas forum for Microsoft’s consideration. If the idea receives enough votes, it will be prioritized. You can submit your idea here.