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

[MichelleBis]

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: 

Screenshot 3:

Screenshot 4:

[lbendlin]

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.