Power Pivot Data Model Extra "Query" tabs

[trisoldee]

Hello,

I'm have a file that I'm getting data from my DB using SQL queries but it looks like every time I refresh the data model and it runs the query, I'm adding another tab in the data model. My first tab is labeled with a specific name, each additional tab is labeled with DB Query 1, DB Query 2, etc...

I'm assuming I have something checked off somewhere that's causing this to happen. I have multiple queries set up in the file but it seems to only happen with one.

How can I stop this from happening so the data overwrites the old data when I refresh instead of creating a new query tab?

Thank you,
Tristan

[Olly]

What steps are you taking to refresh the data?

[trisoldee]

I've been hitting refresh all from the worksheet that my pivots are on and then entering the DB password for the connection.

I went into the data model and deleted all of the redundant tabs, it seems to have resolved itself and is no longer happening. I'm guessing at one point or another when I was first building the file I must have duplicate the query in the data model and that was the one that was replicating.

Thank you.