Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost 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
PC2790's avatar
PC2790
Icon for Community Champion rankCommunity 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
Icon for Post Prodigy rankPost Prodigy
5 years ago

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

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity 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
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Why filter shows options with 0?

      Like Veiklos Pelnas 0 instead Veiklos Pelnas 1.

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Where it could be filtered?