Forum Discussion

Dianica6's avatar
Dianica6
Frequent Visitor
4 years ago

Missing row

Hi 

I have an issue with power bi . A row with information is missing in the table view . 
I went to power query and I filter the specific row ans it is there , when I go to the table view ans filtwr the data is not there , there fore my visuals are not showing the data . 
Any help 

 

Need Help

4 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    4 years ago

    Can you post a picture from Power Query with the data, then another one from data view with the table sorted to show where it's missing from please?

     

    • Dianica6's avatar
      Dianica6
      Frequent Visitor
      4 years ago

      Hi 

      Thanks for looking at this 

      This is my  row filtered in power query 

       

      this is  the table view and i filtered the information and it is not there 

      and if i go to the report and select MAY it should appear at least 1 Item and it is blank 

      if i do a table jus with the incidents reported by Anna May doesnt appear 

       

       

       

    • Dianica6's avatar
      Dianica6
      Frequent Visitor
      4 years ago

      Hi 

      Thanks for looking at this 

      This is my  row filtered in power query 

       

      this is  the table view and i filtered the information and it is not there 

      and if i go to the report and select MAY it should appear at least 1 Item and it is blank 

      if i do a table jus with the incidents reported by Anna May doesnt appear 

       

       

       

  • HotChilli's avatar
    HotChilli
    Community Champion
    4 years ago

    I was hoping for a picture of the data view with a window of data (so showing the rows before and after the missing row) but I can offer some advice based on the provided visuals.

    The first thing I want you to do is load all the rows in Power Query (not just the usual 1000 for preview) and get the rowcount.  Close and apply.  Then check the rowcount in data view.  Please see if there is a discrepancy.

    --

    Next I would like you to experiment by duplicating the query (to use for testing so that you don't lose the original), removing all the query steps after ''Promoted Headers" then select all the columns and change the datatype to Text for them all.  Confirm the row you want to see is there.  Close and Apply.

    Then check this new TestTable in data view and see whether the row is there.

    ---

    I'm not available for a few hours but I will check back if you respond with the results of these tests