Forum Discussion
Backup a dataset table
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.
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.
4 Replies
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__DS0CoreORDER BY'Top50 Microbrewers'[Column1],'Top50 Microbrewers'[Column2],'Top50 Microbrewers'[Column3],'Top50 Microbrewers'[Column4]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.
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.
