cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TomLU123 Member
Member

Store the daily live date into a table

Dear experts, 

 

I am building a report to track the live data in "Live Validation Result Table". This table will refresh daily and the previous day's data will be covered by Today's data. I wish to create a "Validation Result History Table" to store the result of each day so that we can track the trend. Is there any way to write some DAX to create the table to store all the live date?

 

 

Live Validation Result Table

DateEmployee IDValidation Result
8/7/201842222Invalid Gender
8/7/201842223Invalid Gender
8/7/201842224Invalid Gender
8/7/201842225Invalid Location
8/7/201842226Invalid Gender

 

Validation Result History Table

DateEmployee IDValidation Result
8/7/201842222Invalid Gender
8/7/201842223Invalid Gender
8/7/201842224Invalid Gender
8/7/201842225Invalid Location
8/7/201842226Invalid Gender
8/6/201842222Invalid Gender
8/6/201842223Invalid Gender
8/6/201842224Invalid Gender
8/6/201842225Invalid Gender
8/6/201842226Invalid Gender

 

Many thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Store the daily live date into a table

Hi @TomLU123,

 

What you want is like a feature called "snapshot" that allows to store history data without overwriting old data. However, it is not possible to achieve such a requirement in Power BI now. Here is a similar thread: Create "snapshots" on changing data

 

As a workaround, you could create table in a DB to run a SSIS append query, simply adding a date field. That table is then used as data source for Power BI report. 

 

Someone has submitted this feature quest at idea page, you can click to vote it up:

Allow for point-in-time snapshots for reports/dataset

Report history - snapshots. Like in SSRS you can snapshot on schedule. Ability to replay some visual...

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Store the daily live date into a table

Hi @TomLU123,

 

What you want is like a feature called "snapshot" that allows to store history data without overwriting old data. However, it is not possible to achieve such a requirement in Power BI now. Here is a similar thread: Create "snapshots" on changing data

 

As a workaround, you could create table in a DB to run a SSIS append query, simply adding a date field. That table is then used as data source for Power BI report. 

 

Someone has submitted this feature quest at idea page, you can click to vote it up:

Allow for point-in-time snapshots for reports/dataset

Report history - snapshots. Like in SSRS you can snapshot on schedule. Ability to replay some visual...

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.