full parity between Power Query from Power BI and Power Query Excel
Power BI always gets new M functions and features first. The Power Query editor in Excel however, lacks behind a lot. Many functions that are generally available in Power BI desktop never make it to Power Query Excel.
for example: the M function Html.Table has been available more that 2 years in Power BI desktop. But sadly still isn't supported in Excel 365.
Please make all functions and features of the Power Query editor in the free software "power BI desktop" also available in the paid subscription of "Excel 365".