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

Load table append data

Hi Experts!

 

I would like to know it there is any way to do this case:

For example, i have one table, called GENERAL, that if i do a select today will give me the information about june 2021, but if i create the select in August, the table only store the data of August.

 

Conclusion: the table only have info of the current month, and the next month, DELETE and insert the info of the actual month.

 

Is there any way to create a process in PBI, that help me when i do the SELECT * FROM  GENERAL, that persist and append to my HISTORICAL GENERAL TABLE? do an APPEND AUTOMATIC IN PBI,

My table only have the current month, POWER BI will have all my Historical data.

 

Thanks Fernando

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@fkeuroglian Historically there's generally been no clean way to do this in Power BI. However, you might be able to get what you want using Incremental refresh.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@fkeuroglian Historically there's generally been no clean way to do this in Power BI. However, you might be able to get what you want using Incremental refresh.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!