Snapshot Data like Excel

[jimpatel]

Hi,

Thanks for looking at my post.

I have PowerBI with advanced edition where data is coming from SQL. I have set it for schedule refresh on a daily basis. Is there anyway i can take a snapshot and save it in table in power BI like i attached in this forum please? 

Any help will be much appreciated.

Thanks 

Auto run date	Customer name	Value
18/07/2022	Customer 1	£1,313,919.41
18/07/2022	Customer 2	£336,960.22
18/07/2022	Customer 3	£1,075,789.27
17/07/2022	Customer 1	£1,213,919.41
17/07/2022	Customer 2	£346,960.22
17/07/2022	Customer 3	£1,175,789.27
16/07/2022	Customer 1	£1,333,919.41
16/07/2022	Customer 2	£336,960.22
16/07/2022	Customer 3	£1,123,789.27

[jimpatel]

Thats great.

Thanks a lot 🙂

[Anonymous · Accepted solution]

Hi @jimpatel ,

Please refer to the following link if it can help you.

Scheduled Snapshot of the Power BI Data and Report - RADACAD

• Here is the output of the service that scheduled the Power BI report. The Power BI report is creating a snapshot of report and dataset every day (it can be on other schedules too, weekly, or monthly etc). The copy of the report can be created in another workspace in Power BI service as below:

• The copy of Power BI report or dataset is not the only thing that can be scheduled. You can also schedule part of data (as a table) to be exported to CSV files. The CSV file can be sent to your email address on a scheduled basis.

Note:

While Microsoft supports and encourages open-source software development, it does not provide technical support for the software from third parties, nor does it guarantee that the software will work as described.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.