Forum Discussion

pbyrne98's avatar
pbyrne98
Regular Visitor
4 years ago
Solved

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 furthe...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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.

rivthebest's avatar
rivthebest
Frequent Visitor
3 years ago

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?