Forum Discussion

jimpatel's avatar
jimpatel
Post Patron
4 years ago
Solved

Snapshot Data like Excel

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 dateCustomer nameValue
18/07/2022Customer 1£1,313,919.41
18/07/2022Customer 2£336,960.22
18/07/2022Customer 3£1,075,789.27
17/07/2022Customer 1£1,213,919.41
17/07/2022Customer 2£346,960.22
17/07/2022Customer 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
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.