FabCon is coming to Atlanta
Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Go To
- Power BI forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Power Query
- Mobile Apps
- Developer
- DAX Commands and Tips
- Custom Visuals Development Discussion
- Health and Life Sciences
- Power BI Spanish forums
- Translated Spanish Desktop
- Training and Consulting
- Instructor Led Training
- Dashboard in a Day for Women, by Women
- Galleries
- Data Stories Gallery
- Themes Gallery
- Contests Gallery
- Quick Measures Gallery
- Notebook Gallery
- Translytical Task Flow Gallery
- TMDL Gallery
- R Script Showcase
- Webinars and Video Gallery
- Ideas
- Custom Visuals Ideas (read-only)
- Issues
- Issues
- Events
- Upcoming Events
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
- Power BI forums
- Issues
- Issues
- Not all rows from csv file are imported into the P...
Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
0
Not all rows from csv file are imported into the Power BI or Power Query
Submitted by
Anonymous
on
02-09-2022
01:47 PM
Hello There,
I am trying to import data in csv file (size: 585 MB) to Power BI through Power Query.
I am aware that the data in csv file contains more than 1 million rows, but it shows only 1 million rows in Power Query & Power BI as well.
I don't know what exactly went wrong.
Note: I don't have Notepad++
Thank You in advance.
See more ideas labeled with:
Comments
- « Previous
-
- 1
- 2
- Next »
- « Previous
-
- 1
- 2
- Next »
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Latest Comments
- Pig1838 on: DirectQuery not available anymore in Incremental r...
- DataMindedLLC on: 'Refresh Preview' gone from Home Menu Bar in Aug 2...
- qutnd on: Issue with giving Power BI App access to new users
- Sree9100822653 on: undefinedHow to send daily RLS-based Power BI repo...
- Bart_Berg on: Export Data to Excel from powerbi embed reports | ...
- annelebel on: August 2025 Update Changed DirectQuery so each tab...
- manu_panizi on: Direct Query Mode Missing
- Jstukenborg on: Data on Power BI desktop is not refreshing
- noahfox on: Fabric 'Deploy Stage Content' API fails when user ...
- erpfau on: Fields Parameter w. hierarchies: provide option to...
Idea Statuses
- New 8,122
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,278 -
Data Modeling
4,161 -
Dashboards
4,125 -
Gateways
2,122 -
Report Server
2,122 -
APIS and Embedding
1,973 -
Custom Visuals
1,796 -
Content Packs
527 -
Mobile
355 -
Need Help
11 -
Show and Tell
3 -
General Comment
3 -
Tips and Tricks
1 -
Power BI Desktop
1
Hi,
Is there any screenshots or video that can show your error in detail?
As far as I’m concerned, the data size limitation for the import mode dataset is 1 GB, which is highly compressed to around 10x.
What’s more, Import models require from a Power BI service resource perspective:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin