Forum Discussion

EdvanceIQ_Chris's avatar
EdvanceIQ_Chris
Regular Visitor
9 months ago
Solved

Version AsOf in semantic model.

I ingest data via notebooks into CDC enabled lakehouse tables and they enable timetravel for up to 7 years and can be updated up to three times a day.  The select * from table version asof xx works o...
Need Help
  • amitchandak's avatar
    amitchandak
    9 months ago

    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. 

EdvanceIQ_Chris's avatar
EdvanceIQ_Chris
Regular Visitor
9 months ago

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's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
9 months ago

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.

Fabric Ideas - Microsoft Fabric Community

Thank you.