Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Data Snapshots

I am trying to figure out how to go about taking a snapshot of some data. We keep a daily count of our active companies, but things are constantly changing in our database so the numbers always chang...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-fengyz-msft's avatar
    v-fengyz-msft
    8 years ago

    Anonymous

     

    Power BI does not have incremental load at present. This means that if you try to timestamp something at the time of query load, you will get updated values for the timestamp when it is refreshed.

     

    Three options for your reference:

     

    1. Storing and using information from a dynamic data source using PBI desktop

     

    2. Use R script: auto export of data

     

    3. Create a Trigger on source table to insert rows to your DataChangeLog table as soon as the data updated from source table in your database. Colde looks like below:

     

    create trigger triggername On sourcetable

for update

as

insert into destinationtable (column) select column from TriggerTest1

Go

     

    You can vote the idea: Allow for point-in-time snapshots for reports/dataset

     

    Regards,

    Pirlo Zhang 

v-fengyz-msft's avatar
v-fengyz-msft
Helper I
8 years ago

Anonymous

 

Power BI does not have incremental load at present. This means that if you try to timestamp something at the time of query load, you will get updated values for the timestamp when it is refreshed.

 

Three options for your reference:

 

1. Storing and using information from a dynamic data source using PBI desktop

 

2. Use R script: auto export of data

 

3. Create a Trigger on source table to insert rows to your DataChangeLog table as soon as the data updated from source table in your database. Colde looks like below:

 

create trigger triggername On sourcetable

for update

as

insert into destinationtable (column) select column from TriggerTest1

Go

 

You can vote the idea: Allow for point-in-time snapshots for reports/dataset

 

Regards,

Pirlo Zhang 

Recsant's avatar
Recsant
New Member
7 years ago

v-fengyz-msft
I would also love to know more about the create trigger. I'm assuming it's M written into the advanced editor. Is there any documentation you could direct us too.