Forum Discussion

spinachbisque's avatar
spinachbisque
New Member
8 years ago

Records not appearing in report

I created a Power BI report that should have 1420 records imported off an Excel file. When I import the data, Power BI correctly shows that there are 1420 records in the dataset. However, when I crea...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi spinachbisque,

 

When making the update of the darta do you get any error message? 

  • Go to the query editor and check if there is a table with upload errors, you can have some columns that have information that were not possible to convert to the type of data you select on the query editor. Exampl trying to convert text to number.
  • On the table view check if on the bottom the total number of rows is 1420 or 1400

What type of summarization are you placing in the card you are using? Are you using a number column or a text column?

  • Make sure summarization is not for example count distinct.

 

Regards,

MFelix