cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Insert news rows into a existing table

 

Hello community! I need your help.

I have a table in a Excel file like this:

MonthValue
Jan100
Jan50
Jan75
Jan50
Jan20
Jan15

 

This Excel file is the data introduction file for the user, and change the rows values every month.

 

In a Power BI Desktop file, I get this file into a table (ActualTable). In this Power BI Desktop file, I have too a table (HistoricTable) where I want to save the rows of the Excel file but maintein the existents. In the first Update of the file, the ActualTable and the HistoricTable they must have the same rows:

MonthValue
Jan100
Jan50
Jan75
Jan50
Jan20
Jan15

ActualTable & HistoricTable

 

but, when a change the rows of Excel file:

 

MonthValue
Feb10
Feb20
Feb0
Feb50
Feb30
Feb5

 

and I update the Power BI Desktop file again, in the ActualTable I need to have the new rows of the Excel file (from the Feb month) but in the HistoricTable I need to have the previous rows (from de Jan month) and the new rows (from the Feb month), that is:

 

MonthValue
Feb10
Feb20
Feb0
Feb50
Feb30
Feb5

ActualTable

 

MonthValue
Jan100
Jan50
Jan75
Jan50
Jan20
Jan15
Feb10
Feb20
Feb0
Feb50
Feb30
Feb5

HistoricTable

 

How can I do this append method of monthly records?

Thank you very much!

1 ACCEPTED SOLUTION

That is exactly @LivioLanzo! But the Premium option is not possible in this case. I have solved it by importing a windows folder where Excel files are left to load monthly.

Thank you very much for your help, too!

View solution in original post

2 REPLIES 2
Solution Sage
Solution Sage

Hi @Raul

 

this is called 'incremental refresh' and can be set up within Power BI service by using Data Flows. 

If you can't use this feature then you have to load all the data at each refresh.

You can also make a script which stores your excel data into a database (Access for simple ones or SQL Server) so the refresh within Power BI takes less time by loading the data directly from a database. But this requires you to have access to a database plus some coding skills(vba, python etc)

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

That is exactly @LivioLanzo! But the Premium option is not possible in this case. I have solved it by importing a windows folder where Excel files are left to load monthly.

Thank you very much for your help, too!

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors