Load a table with over than 5000000 rows takes for ever

[Anonymous]

I have a table with over than 5 000 000 000 rows to load on Power BI desktop throught import feature, it takes for ever. Any tips to fasten the load ?

[amitchandak]

Refer

https://community.powerbi.com/t5/Desktop/How-to-load-data-faster-or-apply-query-change-faster-from-S...

https://community.powerbi.com/t5/Desktop/Approach-to-load-huge-data/td-p/292811

https://docs.microsoft.com/en-us/power-bi/guidance/

[Mariusz · Accepted solution]

Hi @Anonymous 

Reduce the number of columns in this table or use composite models as per below.
https://powerbi.microsoft.com/en-us/blog/unlock-petabyte-scale-data-sets-in-power-bi-with-aggregations-upcoming-general-availability/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn