Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
hi Guys,
looking for the function in Excel power query and there is no unfortunately HTML.Table function...
How can i achive the same in Excel?
Best Wishes,
Jacek
Solved! Go to Solution.
Hi @jaryszek ,
There's indeed a function called Html.Table in Power Query. Please refer to
Html.Table - PowerQuery M | 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.
Hi @jaryszek ,
There's indeed a function called Html.Table in Power Query. Please refer to
Html.Table - PowerQuery M | 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.
I appreciate this is in the wrong forum (it's posted in PowerBI when it should have been in Excel), but how can this asnwer be marked as an accepted solution? The problem statement clearly states a desire for an equivalent to the Html.Table function in excel PQ, but this is ony available in the PowerBI PQ.
So, is there an alternative option for Excel PQ?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.