Loading Time in Power BI

[Sowmiya]

Hi Community,
Please give your suggestion and tips to reduce the time to load data into Power BI Dataset.

My Source Data is in CSV with large size nearly 15GB.  On Loading the data from Edit Query to Dataset, it is taking a too long time approximately 4-5 hours. My RAM size is 8GB. How to increase my time efficiency.

Thanks in advance,
With Regards,
Sowmiya

[v-lid-msft]

Hi @Sowmiya ,

Based on my research, You can follow this documents to disable backgroud refresh to improve performance in Power Query Editor,

Then you can follow this documents to reduce your data model size by removing unnessary data.

Please refer to the similar post:

https://community.powerbi.com/t5/Desktop/Poor-performance-in-data-refresh-using-multiple-large-CSV-f...

https://community.powerbi.com/t5/Desktop/Can-I-speed-up-of-import-query-from-CSV-file-with-30-000-00...

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.