Insert Table from Power BI Dataset into excel removes duplicate records

Question

I think there is a BUG with the insert Table option for ingesting data into excel from Power BI Dataset.&nbsp; It appears to aggregate rows with identical data, in effect deduping them.&nbsp;&nbsp;&nbsp;Steps to reproduce:1. Create a Dataset that contains two identical rows2. In excel, 'Insert Table' from Power BI dataset.&nbsp;&nbsp;&nbsp;You will see only 1 row, not 2.&nbsp;Insert Pivot Table option does work correctly.&nbsp;&nbsp;&nbsp;Is there a parameter on the Dataset I am missing?&nbsp; I do typically set all my numeric columns to 'None' aggregation.&nbsp;&nbsp;My simple solution is to add a unique identifer (rownum) to each line, but I feel like this should be fixed or I should learn what I did wrong.&nbsp;Thanks,&nbsp;Tim

owenauger · Accepted Answer

Hi&nbsp;AXDevTim&nbsp;
The Insert Table interface is designed to create an Excel table in the same form as a table visual would be created in a Power BI report containing the same columns/measures. This means it is summarized, so each distinct combination of column values appears once in the query result.
&nbsp;
If you want to return the "raw" table instead, one method would be:

Create a table with Insert Table.
Right click the table &gt; Table &gt; Edit Query
In the Command Text box, change the query to EVALUATE YourTable
Click OK

Does this work for you?

&nbsp;

Forum Discussion

Related content

remove duplicate value within a row

Removing Duplicates

How to stop PowerBI from automatically removing duplicates.

Removing duplicates

Remove duplicates bug