I am building a Power BI report that uses a set of SQL temporal tables as source. I would like to provide the user the opportunity of selecting a month from a date slicer and based on that selection, the report would show the valid data AS OF that date.
SQL allows this by using system versioned tables that allow queries such as
SELECT * from table FOR SYSTEM_TIME BETWEEN 'date1' and 'date2'
which would give back all valid values in the table as if the query was run between those dates.
I couldn't find any documentation on how to work with temporal tables in Power BI.
What's the best way of doing this in power BI?
Thanks in advance for your help