Forum Discussion
missing rows in power Bi from Power Query
Hi everyone, I have a problem with a table in my powerQuery importing data to Power BI So I have this table 'History' in my power query, and you can see that there is a value 'PIL-137578' ...
Alright, this solution was weird and I don't remember exactly where I found it. I think it was related to Power Query not propagating a sort on a column or something like that and the solution was to put a "fake" step so Power Query writes somewhere the new sort order.
Anyway, the solution I did was to put a bogus sorting step on one column. I closed and applied and went to check in Table View and my missing two rows now appeared. I went back in Power Query to remove the bogus step then closed and applied. My missing two rows were still there.
No more data was missing for no reason.