Power BI Desktop is not reading correct data from Excel

[Thomas897]

Hello everyone,

I do not have the exact same numbers from my power BI and my Excell file although I got the exact same filters on my columns...

I do not understand...

Thank you !

[Anonymous]

@Thomas897

Can you show your results with screenshots? And possibly elaborate a little more?

[Thomas897]

I have found why, because I have some duplicates on my excell but I want to keep them.

How may I do this ?

[Anonymous]

@Thomas897

I'm honestly not sure what you are trying to accomplish. Can you elaborate?

[Thomas897]

I have different bills of the same amount and the same day and I think power BI does not count them because it thinks they are duplicates. Is that possible ?

[v-huizhn-msft · Accepted solution]

Hi @Thomas897,

It is possible to load the duplicate rows, I create the following sample test, it upload correctly.


The table imported into Power BI
Please check if there is a Power Query like: #"Removed Duplicates" = Table.Distinct(#"Changed Type", {"Date"})



Please revoke the step and check if it works fine.

Best Regards,
Angelia