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?