Copy data from the table to the new power bi desktop table

[Pharamus]

I have a table in the database where data from the last 7 days are stored.

For analysis, I need to collect this data from any period.

How can I copy data from one table to another in a continuous way without duplicating data and without losing data which are automatically deleted from the source table.

Thanks for all the help and suggestions.

[v-jiascu-msft]

Hi @Pharamus,

Please refer to this post. There isn't a direct way for now. Please create an idea here.

Best Regards,

Dale