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 filt...
Need Help
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