Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Sometimes we need to import fairly large datasets into power bi and can take a while.
Currently don't have access to premium thus cannot use incremental refresh.
Is there an option e.g to increase the bulk size when it imports data. to speed this up?
Have seen some other tools where can increase array fetch size to collect more rows with each fetch.
and wondered if power bi has anything similar.
Thanks
Solved! Go to Solution.
hi, @po
Incremental refresh is only supported for power bi premium for now. And there is no similar way like it.
For your requirement, The best way is optimize your model:
remove unnecessary tables or columns, reduce unnecessary steps, etc.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
https://community.powerbi.com/t5/Desktop/Importing-and-applying-data-changes-too-long/td-p/396803
https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
Best Regards,
Lin
hi, @po
Incremental refresh is only supported for power bi premium for now. And there is no similar way like it.
For your requirement, The best way is optimize your model:
remove unnecessary tables or columns, reduce unnecessary steps, etc.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
https://community.powerbi.com/t5/Desktop/Importing-and-applying-data-changes-too-long/td-p/396803
https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
Best Regards,
Lin
Thansk for update
User | Count |
---|---|
102 | |
84 | |
77 | |
70 | |
67 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |