Forum Discussion

RicardoV2's avatar
RicardoV2
Frequent Visitor
3 years ago

Visual data Export to Excel is removing lines

Hello,

I have a table visual with something like 19430 lines being shown, I've verified on the report, and that same number appears in Excel online when using Analyze in Excel. Though that, when i do the export of table data's visual to Excel, exactly with the same filters, only 18740 lines are being exported.

Meanwhile I've seen Export data from a Power BI visualization - Power BI | Microsoft Learn , tried to change option in Options \ Current File Report Settings \ Export Data to the 2nd option but # lines in export is the same, and also just showing 6 columns 

 

 

 So, what can be happening here?

 

Thanks

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    RicardoV2 how you verified 19430 rows? Do you have only columns or there are measures as well on the visual you are trying to export from?

    • RicardoV2's avatar
      RicardoV2
      Frequent Visitor
      3 years ago

      Hello @parry2k  , I've verified in multiple ways: by changing table columns from "Don't Summarize" to "count", to creating a calculated column with value 1 and summing it, and also online in "Analyze in Excel". 

      I'm using only columns.

  • RicardoV2's avatar
    RicardoV2
    Frequent Visitor
    3 years ago

    Hello parry2k  , I've verified in multiple ways: by changing table columns from "Don't Summarize" to "count", to creating a calculated column with value 1 and summing it, and also online in "Analyze in Excel". 

    I'm using only columns.

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    RicardoV2 If there are duplicate rows it will show as one row and that might be the reason that it is showing fewer lines. Try this: add an index column in Power Query and then bring this index column in the table visual (no summarize) and then check. It will make each row unique.