Power Query loading default SharePoint list view instead of all columns

[elsiegit]

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.

[Ashlesha-MSFT]

Hello @elsiegit
Thank you for bringing this issue to our attention. We will look into it and get back to you shortly.

[Ashlesha-MSFT]

Hi @elsiegit,
Thank you for your patience. I was able to reproduce this behavior in our test scenarion, Power Query is loading data aligned to the default SharePoint view instead of returning all columns as expected.
Based on this, I’m treating it as a confirmed product bug and escalating it to the owning engineering team for investigation.
The engineering team will review and provide a fix or mitigation through the product update path.
I’ll keep this issue updated as soon as I receive progress from engineering.