Powerpivot Excel 2013 creates new tables automatically on refresh

[rileybloke]

Hi,

I have developed a Powerpivot project using Excel 2013. It queries data from Oracle and Other Excel sheets.
I have noticed that after data refreshes it creates new tables of data inside the model called Query1, Query2, Query3 etc. incrementing each time.

The data in these tables is repeated each time and contains the same data from one of the current tables queried from Oracle. Most of my Measures (calculated fields) are created in this table.

I search the web, and found numerous posts but none have an answer.

Has anyone seen this behaviour before?

Thanks
Phil

 

[scottsen]

I had a client report that recently, and I almost didn't believe her

Do you have the latest bits? There was an update to Excel / PowerPivot 2013 a month or so ago, wondering if the "other" version doesn't have this issue?

Unfortunately she ended up recreating her model to get this problem to go away.