Forum Discussion

Thomas897's avatar
Thomas897
Icon for Helper I rankHelper I
9 years ago
Solved

Power BI Desktop is not reading correct data from Excel

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 !
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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


Thomas897's avatar
Thomas897
Icon for Helper I rankHelper I
9 years ago

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's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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