power bi counts more rows than in file excel or text

[ozmike]

Hi I import a excel file with 491 , records and power bi reports 240100 rows? with the countrows( table) function. If i export the excel to csv or text , I still get a row count of 240100 rows. If import the same same xls into msacces  it reports 941 rows. I also had a large xls that had about 13000 rows and power bi reported 1.4 million row again i'm not joining or merge just a raw file.. This is driving me crazy. I even opened up a new power Bi file and it still happens. Interestingly if I make a file with just 2 rows power bi does report 2 rows! so thats a start - what is causing this? 

mike

[Phil_Seamark]

Hi @ozmike,

Maybe your source excel file has lots of empty string type values?

Any chance you can post a copy of your Excel file?  PM a link if you want to keep it semi private.

Cheers,

Phil

[Sean]

Is your Data in Excel formatted as a Table?
If not click inside the range and press Ctrl+T
Assign a name or remember the generic that's generated
Then when you import into PBI select the Table Name not the Sheet on which the Table is!
Hope this helps!

[ozmike · Accepted solution]

Thanks i think I've got it , I was making a new column as a column not a measure so it was summing the data  in the display ! good waste of a day! Thanks for your help as soon as you ask for help the you don't need help! - at least for me!