Forum Discussion

ammeijs's avatar
ammeijs
Icon for Helper I rankHelper I
5 years ago
Solved

Data table does not show all rows (query editor does) in new report

Hi all, 

 

I cannot seem to find the right answer. I stumbled upon a strange issue...

 

I just opened a new .pbix report. So no changes or filters are been made in this report. The only thing I did is upload a Excel dataset. As you can see in the photo below, the data table is only showing 117 of the 136 rows... And when I open the data in the Query Editor, it does show all rows. Where does it go wrong?

 

 

If I upload other Excel datasets, this problem does not occur. I really do not know what to do anymore. Who can help me out? 

 

Need Help
Show and Tell
Tips and Tricks
  • negi007's avatar
    negi007
    5 years ago

    ammeijs  I suggest you to create a measure to check number of rows in the table. Sometime while scrolling you may not be able to see all rows.

     

    Rows_In_Tab= COUNTROWS('Tab1')

4 Replies

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 years ago

    ammeijs  I suggest you to create a measure to check number of rows in the table. Sometime while scrolling you may not be able to see all rows.

     

    Rows_In_Tab= COUNTROWS('Tab1')
  • ammeijs's avatar
    ammeijs
    Icon for Helper I rankHelper I
    5 years ago

    negi007 the card shows 136 'rows_in_tab'. Which corresponts with the amount of rows in the Query Editor. Does this mean that all rows are used for measures/visuals/calculations even though I cannot see them in the Data Table? 

    And you say sometimes while scrolling. However, I cannot see the missing rows every single time. I find this weird. 

     

    Anyway, thank you for your quick reply!

    • negi007's avatar
      negi007
      Icon for Community Champion rankCommunity Champion
      5 years ago

      ammeijs If row count is correct then I think there is no issue with your data. It is pulling all rows it is just that while scrolling you are not able to view it. You may also try copy and paste your data from powerbi table to excel file to check if everything is there. Also, you may also try using some calculation to ascertain if numbers are matching or not. 

       

      Cheers!!!

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    ammeijs , Power Query show sample data. Is your row count /data is correct.

     

    In Dax create this measure and check countrows(Table)