cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
po Member
Member

Speed up import possible ?

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Speed up import possible ?

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

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

Re: Speed up import possible ?

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

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

Re: Speed up import possible ?

Thansk for update