How can I limit the number of columns using $expand within $select?

[Anonymous]

Hi all,

I have a table with 997 columns, but cannot return all the data because of this message below, does anyone knows how can I use $expand to return just 800 columns?

DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (VS403483: The query specified in the URI is not valid: VS403670: The specified query returns 997 columns which is higher than the allowed limit of 800 columns. Please, use explicit $select (including within the $expand) options to limit number of columns..)
OData Version: 4, Error: The remote server returned an error: (400) Bad Request. (VS403483: The query specified in the URI is not valid: VS403670: The specified query returns 997 columns which is higher than the allowed limit of 800 columns. Please, use explicit $select (including within the $expand) options to limit number of columns..)

[v-shex-msft]

HI @Anonymous,

What type of data source are you worked on? Can you please share more detailed information to help us clarify these?

How to Get Your Question Answered Quickly

If you are work with eh data sources that allow using advanced queries, you can add filters to limit the result query table fields. (e.g. SQL, OData)

Regards,

Xiaoxin Sheng

[sayaliredij]

When you click on to expand, power query gives you the option to select columns 

Eg. In following table

Select the one you want 

Regards,

Sayali 

If this post helps, then please consider Accept it as the solution to help others find it more quickly.