Power Query loading default SharePoint list view instead of all columns

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

SharePoint REST API

Developer environment

None

What browser(s) / client(s) have you tested

• 💥 Internet Explorer
• 💥 Microsoft Edge
• 💥 Google Chrome
• 💥 FireFox
• 💥 Safari
• mobile (iOS/iPadOS)
• mobile (Android)
• not applicable
• other (enter in the "Additional environment details" area below)

Additional environment details

Microsoft® Excel® for Microsoft 365 MSO (Version 2605 Build 16.0.20026.20166) 64-bit

Describe the bug / error

When using the SharePoint list connector in power query for Excel, I have lists which are supposed to load all columns, but have recently started loading only rows/columns shown in the default view. This change has happened recently.

M:
= SharePoint.Tables("https://XXX.sharepoint.com/sites/XXX", [Implementation="2.0", ViewMode="All"])

Steps to reproduce

1. Create a connection to a SharePoint list in Power Query for Excel (Data > Get Data > From Online Services > From SharePoint Online List
2. At the dialogue, select implementation 2.0 and view mode - ALL columns
3. Load the data from the list and validate that columns/rows missing from the list's default view are not loading.

Expected behavior

I expected all rows and columns to load, because this is what has been selected.