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.
Go to Solution.
@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.
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!