Forum Discussion

AXDevTim's avatar
AXDevTim
Frequent Visitor
1 year ago
Solved

Insert Table from Power BI Dataset into excel removes duplicate records

I think there is a BUG with the insert Table option for ingesting data into excel from Power BI Dataset.  It appears to aggregate rows with identical data, in effect deduping them.     Steps to rep...
Need Help
  • OwenAuger's avatar
    OwenAuger
    1 year ago

    Hi AXDevTim 

    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.

     

    If you want to return the "raw" table instead, one method would be:

    1. Create a table with Insert Table.
    2. Right click the table > Table > Edit Query
    3. In the Command Text box, change the query to EVALUATE YourTable
    4. Click OK

    Does this work for you?

     

OwenAuger's avatar
OwenAuger
Super User
1 year ago

Hi AXDevTim 

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.

 

If you want to return the "raw" table instead, one method would be:

  1. Create a table with Insert Table.
  2. Right click the table > Table > Edit Query
  3. In the Command Text box, change the query to EVALUATE YourTable
  4. Click OK

Does this work for you?