Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Data table not match excelltable

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:

 

 

Need Help

9 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    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's avatar
      Analitika
      Post Prodigy
      5 years ago

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

      • PC2790's avatar
        PC2790
        Community Champion
        5 years ago

        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's avatar
    Analitika
    Post Prodigy
    5 years ago

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

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

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

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.