Forum Discussion
Load a table with over than 5000000 rows takes for ever
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 ?
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
2 Replies
- Mariusz
Community Champion
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
