Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |