CSV File Data Issues

aacptl · ‎06-19-2023

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?

danextian · ‎06-19-2023

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.

TheoC · ‎06-19-2023

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