Forum Discussion
Backup a dataset table
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.
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:
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.