Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pbyrne98
Regular Visitor

HTML.Table : Expression.Error: The name 'Html.Table' wasn't recognized.

Hi,

Does HTML.Table requre a certain version of PowerQuery?

 

Using the forums I've tried the below code in a Custom Column and get the error in bold.

Other examples of code I've tried are further down. Additionally I've added screen shots of what I'm trying to do.

 

Expression.Error: The name 'Html.Table' wasn't recognized. Make sure it's spelled correctly.

 

 

= Html.Table([#"Last Week's Achievements"],{{"Application","tr>:nth-child(1)"},{"Version","tr>:nth-child(2)"}},[RowSelector="tbody>:nth-child(n+2)"])

 

 

 

= Html.Table([#"Last Week's Achievements"],{{"PlainText",":root"}})

 

 

Column to convert to PlainTextColumn to convert to PlainTextSolution from YouTubeSolution from YouTubeErrorError

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

Looks like you are using Excel Power Query. Currently, Html.Table is supported only in Power BI Desktop (and PQ Online) but not in Excel PQ. If you use Power BI Desktop, you will be able to make it work.

View solution in original post

4 REPLIES 4
Bijaelo
New Member

The topic is quite stale. 

 

For many purposes, you can get around the lack of Html.Table by unfolding the html contents using Web.Page. Eg. if you have a list containing html contents, you can use "Web.Page(contents)" to unfold the contents, and then walk down to the elements you want to return. 

jaryszek
Post Patron
Post Patron

Hi Guys,


what is equivalent in Excel to do this?

Vijay_A_Verma
Super User
Super User

Looks like you are using Excel Power Query. Currently, Html.Table is supported only in Power BI Desktop (and PQ Online) but not in Excel PQ. If you use Power BI Desktop, you will be able to make it work.

I have also experienced similar issue. I am just wondering if the Power Query unit available for the Desktop version of Excel(O365) and Power Query available for Desktop version of Power BI are 2 different entities? Then it would be quite difficult to utilize Power Query seamlessly across the products. Is there any way we can verify the version of Power Query unit used for the respective applications like Desktop version of excel (O365) and/or Desktop version of Power BI?

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors