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.
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.
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.