Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
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?
Can you please suggest me how can it fixed?
Solved! Go to Solution.
Hi @aAmirkHan ,
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 for troubleshooting tips. Finally, you can refer to and 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 and for more information on refreshing data in Power BI.
Reference:
Best practices when working with Power Query - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your update.
Hi @aAmirkHan ,
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 for troubleshooting tips. Finally, you can refer to and 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 and for more information on refreshing data in Power BI.
Reference:
Best practices when working with Power Query - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.