To do that, select the Data tab, highlight the table, and click From Table/Range in the Get & Transform Data command group of the ribbon. In the Power Query editor, select the columns you want to ...
The native v1 and v2 SharePoint list connectors are incredibly slow. I've seen refreshes take over two hours just to load multiple lists. This is often attributed to the "greediness" of the connector ...