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.
Hi MikeGaunt1986
Power BI will not append rows by itself.
You need to handle this on the Snowflake side.
Step 1: Create a Log Table
CREATE OR REPLACE TABLE LOAD_LOG (
LOAD_DATE TIMESTAMP
);
Step 2: Insert on Every Refresh
Instead of just using CURRENT_TIMESTAMP() in your SELECT, add an insert step:
INSERT INTO LOAD_LOG (LOAD_DATE)
SELECT CURRENT_TIMESTAMP();
Step 3: Load This Table in Power BI
-
Import LOAD_LOG into Power BI.
-
This table will now keep all refresh timestamps as history.
-
You can visualize refresh frequency and trends over time.