Forum Discussion
Solved
Load Date
Hi all, I have a fairly simple app that links to snowflake to get the data. Within the snowflake dataset I have a field CURRENT_TIMESTAMP() AS LOAD_DATE Which works fine and everyt...
Power BI doesn't store a historical copy of the data. It picks up the most recent data upon refresh. Aside options provided by the other users and if you are on Fabric, you may use a dataflow then load it as append.
Are you using microsoft fabric? Easiest approach would be to use Incremental refresh in service.
If you control the Snowflake side:
-- one-time setup
CREATE TABLE FACT_SNAPSHOT AS
SELECT *, CURRENT_TIMESTAMP() AS LOAD_DATE
FROM SOURCE_TABLE;
-- each refresh (could be called from Power BI or a Snowflake Task)
INSERT INTO FACT_SNAPSHOT
SELECT *, CURRENT_TIMESTAMP() AS LOAD_DATE
FROM SOURCE_TABLE;
If you don't control it and have access only upto fabric:
Create a Dataflow with the original query.
In Power Query, add a custom column:
RefreshDate = DateTime.LocalNow()In Power BI Service, set the dataset storage mode to Append (Dataflow + Incremental Refresh).
This keeps past refreshes.
Please let me know if it works!
Best Regards,