Table panel for table transform

I am using grafana + prometheus, I am wondering if there is a way to stop grafana
adding the same query results in table as new rows when I choose Table Transform as Table?

The problem here is that I set the refresh interval as 5s and want to show some metrics in Table format, but grafana keeps adding new rows to the table with the same metric every time it executes an query.

I could not reproduce this locally but that sounds like a bug unless you are writing data every 5s?

Can you show the raw query and the raw data from two queries? Here is a guide on how to get the raw data from the Chrome Developer Tools.