Forum Discussion

mesuyog's avatar
mesuyog
Regular Visitor
4 years ago
Solved

Data row count changes after export

Hi I have imported the data into power bi desktop. After import when i put the same data into table it and extracted the same. The row count reduces. When i count the rows using "countrow" the count ...
Need Help
  • JirkaZ's avatar
    JirkaZ
    4 years ago

    Then you can add an index column to your data and add it to the exported table. That should prevent the duplicates being removed. 

     

    Anyway using Power BI as an "Excel" exporter is not really what it's built to do. 

    If you really need to use the data in Excel, use Analyze in Excel instead.

JirkaZ's avatar
JirkaZ
Solution Specialist
4 years ago

If you put a number field into matrix "Values" section, it will automatically perform the defined aggregation (typically SUM). If you put it in the rows or columns section, it will remove duplicates. That's a standard and expected behavior. 

 

You can use the standard table and set the field to "Do not summarize".

mesuyog's avatar
mesuyog
Regular Visitor
4 years ago

Thanks for the solution....but I have used Table only and made it do not summarize ... still its giving the same issue...

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    4 years ago

    Then you can add an index column to your data and add it to the exported table. That should prevent the duplicates being removed. 

     

    Anyway using Power BI as an "Excel" exporter is not really what it's built to do. 

    If you really need to use the data in Excel, use Analyze in Excel instead.

    • mesuyog's avatar
      mesuyog
      Regular Visitor
      4 years ago

      Thank you...Indexing worked....