Forum Discussion
Slow CSV import
Hi mwegener and v-easonf-msft,
It turns out that it was a rookie mistake. I was processing my data during the import process which was causing the import to be ridiculously slow. I've since imported the CSVs as is and am applying the calculations to the imported data, which has reduced the import process from 90 minutes to < 10 seconds!
Lesson learned, now just to figure out how to get my formulas to work again (since I now have combined data in one table instead of individual tables).
Thanks for the feedback, though!
Hi , andygoes
As mentioned in this document, the maximum file size you can import into Power BI is 1 gigabyte.
When you try to publish to service, even with a Pro License, a single PBIX file is limited to 1GB (you can have a total of 10GB saved under one account, but an individual file is limited to 1GB). You might actually be able to publish it, but you will not be able to refresh the data online.
And in the import mode, large data will take a long time to load. So it is generally recommended to convert to directquery mode.
You may take a try to load csv to SQL Server and use DirectQuery in Power BI Desktop to connect to the SQL data source.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm plagued with slow CSV files that are work fine intially but after a PowerBI crash start taking forever to load. I've got them on onedrive. Do you have any links for how to use directquery?