Data table not match excelltable

[Analitika]

Hello,

I would like to ask why my data table differs from excel table? My report import excel file.

Here is in data view in Power BI.

Here is in excel:

[Anonymous]

@Analitika 

Have you double checked to make sure that the excel data is in a table format? or all the rows are in a table format?

You can try the following:

Remove all formatting in the excel file by selecting all the rows and then Clear > Clear Formats under the Editing tab. The Power BI report now brings in all the rows.

Best Regards,

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

[PaulDBrown]

strange indeed... something you can try is select the range of data in Excel and transform it into a table (ctrl + t)

When you then point the source to the file, it will detect the table which you can then import. All the data should be imported

[Analitika]

I can't share report it contains confidenial data. I checked advanced editor in there is ok.

[Analitika]

Yes I have checked. I already made refresh all and also excel is used same. So I don't get where is a problem?

[PC2790]

Try refreshing once and also in Power Query check for the applied steps in case any of the step is limiting the data.

Also, make sure that the source is pointing to the same excel having the three records

[Analitika]

Also when press transform data, then I see that it match as in excel file.

[PC2790]

Alright! That means the data is coming.

It's just getting filtered at some step.

Would it be possible to share your report? Or from Power Query Editor please share the Applied Steps by going into Advanced Editor

[Analitika]

Where it could be filtered?

[Analitika]

Why filter shows options with 0?

Like Veiklos Pelnas 0 instead Veiklos Pelnas 1.