Missing row

[Dianica6]

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 

[HotChilli]

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

[HotChilli]

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]

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]

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