Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MichelleBis
Regular Visitor

How to retrieve columns that are not included in the default view of Sharepoint Online List

Hi everyone, 

 

I'm currently working for client that wants me to build a report with one of its SharePoint Online Lists. My problem is that Power BI only provides two options for retrieving sharepoint lists: 1) All Columns or 2) Columns in Default view. My second issue is that the client doesn't want me to modify the default view or create a new one, but the current default view is not including certain columns of data that I need. On the other hand, the "retrieve all columns" option will not work for me either, since the total number of columns is 73 (See screenshot 1)

I noticed that when I select the "Default- Retieve the columns set in the "default view".." I can easily retreive the complete list with all recods (see screenshot 2, 3 and 4) but when I select the "All - Retrieve all Columns..." I get an error. My third problem, is that the client asked me not to modify the "default view" or to set a different view as the "default". 

Does anyone know if its possible to reteive only certain columns or add columns to the default view using an M code at the Query Editor? At  this point I'm open to any suggestions, I'm thinking that the only solution might be to develop an M code but please feel free to suggest otherwise. Any help will be much appreciatted. Thanks in advance!

 

Michelle 

 

Screenshot 1:

 

Screenshoot 2: 

MichelleBis_2-1694025372563.png

Screenshot 3:

MichelleBis_3-1694025705043.png

Screenshot 4:

 

MichelleBis_4-1694025896600.png

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

On the other hand, the "retrieve all columns" option will not work for me either, since the total number of columns is 73

That is not nice but should not prevent you from pulling them all, as long as you don't try to expand any of the lookup columns.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.