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

Hi  Anonymous 

You mentioned that "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 ?

You created measures in table PBI_Measures and then switch the connection to different Power BI dataset , then reconnect to the original dataset,right ?

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?

I'm a bit confused and look forward to your reply!

Best Regards,
Community Support Team _ Ailsa Tao