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