Issue with Power BI Desktop deduplication on changing datasource (direct query to Power BI Dataset)

Hi Anonymous thank you for your quick reply! 

When I revert the connection back to the original dataset the duplicated table vanish which is what I expect. " , can you explain it in detail ?

Your assumption with reconnecting to the original dataset is correct. In my example the one called COBI_ALL_DATASET. The duplication of the table PBI_Measures is reverted when I change back to the original dataset. What I expect from Power BI is written below 🙂 I basically want Power BI to not duplicate tables if the aren`t any duplicate tables.

You also mentioned that "When I move both measures to a different table, the PBI_Measures table does not get duplicated." ,what is the outcome you want to achieve? As you said above, you want it to vanish. Now wouldn't MEASURE not have a duplicate value be exactly what you expect?

The explanation was a bit unclear from my side my bad. The general problem is that tables are seemingly randomly duplicated when I switch the dataset connection.

Expectation from Power BI from my end:

Power BI should replace all tables with the ones from the new connection and move all measures and calculated columns to the new table.

When I switch to a dataset that has exactly the same structure I do not want Power BI to duplicate any table as there are no duplicate tables when I just switch the connection. I expect Power BI to replace the tables. In my example I thought Power BI would change the connection and "replace" the table PBI_Measures as there is only one table called PBI_Measures.

What actually happens:

Power BI duplicates the table PBI_Measures, puts the column "dummy_table" in the duplicated table called PBI_Measure 2 and leaves the created Measures in the table called PBI_Measures. This behaviour changes when I move the two measures to a different table. In that case Power BI replaces the table PBI_Measures as is expected. 

The table I move the measures to (in my example vDIM_Account) then does not get duplicated when I switch the dataset connection. 

• Why does Power BI duplicate the table PBI_Measures if there are Measures associated with this table?
• Why does Power BI then not duplicate the table vDIM_Account if I move the Measures there?

I hope that makes the challenge a bit more understandable.

Thanks again!

Timo