Backup a dataset table

[DataVitalizer]

Hi Community,

My dataset is composed of 3 related tables, the values of one of these tables get updated (same rows with updated numbers).

I wanr to know if there is a solution to export that table to excel before it gets updated in order to maintain historical data?.

Thank you in advance.

[foodd]

This may meet your need, where you wish to connect to a dataset at a point in time.  It is 

a very fast and pleasant user experience.  Do take in mind that this is just rolling out.

Announcing new ways to create connected tables in Excel connected to Power BI

By Lukasz Pawlowski, Principal Program Manager, August 23, 2023. 

Connection properties: 

Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-a58a1561-1e04-42a2-be92-0fb6b899c374;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 929d0ec0-7a41-4b1e-bc7c-b754a28bddcc;Update Isolation Level=2

Expression:

DEFINE VAR __DS0Core = 

SUMMARIZE(

'Top50 Microbrewers',

'Top50 Microbrewers'[Column1],

'Top50 Microbrewers'[Column2],

'Top50 Microbrewers'[Column3],

'Top50 Microbrewers'[Column4]

)

EVALUATE

__DS0Core

ORDER BY

'Top50 Microbrewers'[Column1],

'Top50 Microbrewers'[Column2],

'Top50 Microbrewers'[Column3],

'Top50 Microbrewers'[Column4]

[DataVitalizer]

Hi @foodd 

I read the article and it looks interesting for the need to connect Power BI dataset into Excel.

My need was the following, I have a pusblished dataset with 3 tables (A, B and C).

The table C contains 3 columns (Employee, Product, sold), here is a sample

Employee	Product	Sold
Employee1	Prod2	400
Employee2	Prod5	500

After the scheduled refresh, the table will contain these data

Employee	Product	Sold
Employee1	Prod2	410
Employee2	Prod5	500
Employee3	Prod1	350

Since the values are replaced, I need to automate storing all cumulative data of Table C in Excel before each dataset refresh to be able to use it later.

Thank you in advance.

[foodd]

This is a manual process, of course, it is however an option.   Look into Power Automate for a  scheduled solution for quick solution against your scheduled refresh.

[DataVitalizer · Accepted solution]

Unfortunately I did not find any, I will check the incremental refresh though I was looking for a solution which does not require premium license.