Slow data refresh in Power Query

Question

Hi,&nbsp;I am updating data type as (changed type) of each column in Power Query. So it is taking huge time to update each field in column. However, I am fetching data from sharepoint in Power Query?&nbsp;Can you please suggest me how can it fixed?&nbsp;&nbsp;&nbsp;amitchandak&nbsp;

anonymous · Accepted Answer

Hi&nbsp;aAmirkHan&nbsp;,
&nbsp;
It seems that you are experiencing slow data refresh in Power Query while updating data type of each column. According to, slow data refresh in Power Query can be caused by slow data source, slow network connection, or PowerQuery. You can try to optimize your data source or network connection to improve the performance. Additionally, you can try to optimize your Power Query by reducing the number of steps or using more efficient transformations. If you are using SharePoint as your data source, you can refer to&nbsp;for troubleshooting tips. Finally, you can refer to and&nbsp;for more information on refreshing data in Power BI.
It seems that you are experiencing slow data refresh in Power Query while updating data type of each column. According to, slow data refresh in Power Query can be caused by slow data source, slow network connection, or PowerQuery. You can try to optimize your data source or network connection to improve the performance. Additionally, you can try to optimize your Power Query by reducing the number of steps or using more efficient transformations. If you are using SharePoint as your data source, you can refer tofor troubleshooting tips. Finally, you can refer to&nbsp;and&nbsp;for more information on refreshing data in Power BI.
Reference:
Best practices when working with Power Query - Power Query | Microsoft Learn
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Slow data refresh in Power Query

2 Replies

Related content

Excel Power Query Refresh

Power Bi refresh

Power Query dates

Refresh Direct Query not refreshing

Data transform using power query