Return to site

Import html tables into excel for mac

broken image
broken image

The reason table highlights are displayed in Power BI Desktop for pages where they are not displayed in Excel, is that Once you create your query, you can copy-paste it into Excel and proceed there. To the same web page using Power Query in Power BI Desktop. This is what the message indicates: 'Table highlighting is disabled because this page uses Internet Explorer's Compatibility it seems that you are experiencing both issues, even though the two issues are not if in your case you get the 'Table highlighting is disabled because this page uses Internet Explorer's Compatibility Mode' message, but Power Query is recognizing the tables, you should be able to see the table highlights by connecting Mode prevents these table highlights from being properly displayed. Some pages, however, are automatically opened in Compatibility Mode by the Internet Explorer browser that runs in the Navigator dialog, and Compatibility

broken image

This is not related to the Compatibility Mode mentioned in the message.Ģ) If tables in the web page are recognized by Power Query, these tables are highlighted in the Web View. This is what happens when only one 'Document' This depends on how those tables are defined in the HTML code (for example, if they are defined as tags instead of tags). 1) Some web pages contain tables that Power Query doesn't recognize.