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: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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
578 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
537 Views
0
TheoC
Community Champion
Community Champion

‎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
540 Views
0

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All