Missing Rows in Data Model

[Laur1987]

Hi,

I have this problem: I upload a csv file in Power BI Desktop. In Power Query everything is ok.  See voucher_code (2019A00001, 2019A00002,2019A00003,2019A00004,2019A00005.)

But in data model is missing some rows example: 2019A00001, 2019A00002,2019A00010,2019A00011.

See the attachements.

Can somebody help me?

Thanks!

@tamerj1 

[Anonymous]

Hi @Laur1987 ,

Please check if you have used the filters on the data table.

Just to double check, have you refreshed the data preview in the Query Editor recently? Just wanting to check that the data you're looking for is still in the data source itself.

If it's there, but not showing up in Table view, be sure to right click the top of the column and clear all filters.

If it STILL doesn't show up, try filtering in ONLY the missing data from the Query Editor and see if it shows up in your visuals. It would also be helpful if you could recreate a subsection of the data and share the .pbix with us.

I have also found a similar post, please refer to it to see if it helps you.

Adding Missing Rows - need help! 

Data Missing in Table Visual and Filter 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Laur1987 , Please filter and check. Data view display might not have same order as power query

ALso check for any error in power query

[Laur1987]

@amitchandak@truptis