Showing results for 
Search instead for 
Did you mean: 
pmscorca Member

Adding current rows in an historical table


with PBI I'm reading a table available on a web site. This table is upated on daily basis with rows related to the current month. The next month, this table will start to zero in order to show the rows related to the next month.

So in my data model I've created a current month table to acquire data from the current month web site table, and I've created to an historical table by an append query operation from the current month table.

It seems that a such approach doesn't function because in the historical table the rows aren't added from the append query action.

Now, any suggests to me to solve this issue, please?


Many thanks

Community Support Team
Community Support Team

Re: Adding current rows in an historical table



Currently, there is no elegant way. You may leave a comment on this idea.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.