Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
aacptl
New Member

CSV File Data Issues

‎06-19-2023 02:02 PM

Hi Everyone,

 

I have a CSV file that updates with all GL data daily, but after 6/13/2023 I am unable to import into PowerBi. It seems that I have hit a capacity limit of some sort, but I have well under 2M rows. Anyone have any advice?

Labels:
Message 1 of 3
464 Views
0
2 REPLIES 2
danextian
Super User
Super User

‎06-19-2023 05:11 PM

Hi @aacptl ,

 

How is the CSV file being updated? Is it downloaded from a system or is the new data manually added? CSV can store millions of row but If you manually update the file in Excel, the number of rows is limited only to a 1million+

Also, what errors are you getting?





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 3 of 3
423 Views
0
TheoC
Super User
Super User

‎06-19-2023 04:21 PM

Hi @aacptl 

 

CSV files have max of around 1.049m rows.  My recommendation is changing your data source to a folder rather than a single CSV file.  By doing this, you can have hundreds of CSV files at ~1.049m rows and you won't have any issues.

 

Hope I have understood the issue at hand. If not, let me know.

 

Theo 

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Message 2 of 3
426 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All