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.
sivarajan21
Post Prodigy
Post Prodigy
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,