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


5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thomas897

     

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

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

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

      How may I do this ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Thomas897

         

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