Forum Discussion
How to import large csv file in powerBI
Super UserHello Techinmay,
You do not really need PowerShell for this. Microsoft Power BI Desktop can handle large CSV imports directly.
What normally helps is:
1. Importing through Transform Data instead of loading straight away
2. Removing unused columns early
3. Filtering rows before doing other transformations
4. Setting data types manually if detection becomes slow
If the data is split across multiple CSVs, the Folder connector works well too.
CSV sources also do not support query folding, so all transformations happen locally in Power Query. Keeping the dataset as small as possible early in the steps usually improves performance.
Hey Everyone,
I searched a lot for how I could easily import a large CSV file into Power BI, then I found out that if your CSV file is too large to import into Microsoft Power BI, the best solution is to split the CSV into smaller parts before importing.
As it can cause slow loading, memory issues, or import failures in Power BI. So for that, I found one of reliable software, which is SysTools CSV Splitter Tool to divide a huge CSV file into multiple smaller files without losing any data. The software allows users to split CSV files by rows, size, or columns, which makes it easier to manage and upload data into Power BI smoothly.
After splitting the file, simply import the smaller CSV parts one by one into Power BI for faster processing and better performance.
If someone is also facing the same issue, then they can refer to this solution.
Thanks,
Techinmay