Forum Discussion
Getting simple HTML table from html file is very slow
Hi gancw1 ,
You can reduce unnecessary data before importing.
Or you can use the "From Web" option in Power Query to read the HTML table directly from the SharePoint site first. And then clean up the data in Power Query for the next load or refresh.
You can remove unnecessary columns, rename columns, and change data types to optimize the data for your needs.
Use the "Close & Load" option in Power Query to load the data into it. This will create a connection to the SharePoint site, and you can refresh the data whenever you need to.
If the above steps do not work, you can try running a scheduled Power Automate task to use Excel online to convert the HTML table into CSV or XLS format.
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.
Hi gancw1 ,
You can reduce unnecessary data before importing.
Or you can use the "From Web" option in Power Query to read the HTML table directly from the SharePoint site first. And then clean up the data in Power Query for the next load or refresh.
You can remove unnecessary columns, rename columns, and change data types to optimize the data for your needs.
Use the "Close & Load" option in Power Query to load the data into it. This will create a connection to the SharePoint site, and you can refresh the data whenever you need to.
If the above steps do not work, you can try running a scheduled Power Automate task to use Excel online to convert the HTML table into CSV or XLS format.
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.
I am going to explore using a scheduled Power Automate task to use Excel online to convert the HTML table into CSV or XLS format.