Power BI Desktop MoreColumns not showing all columns

[Anonymous]

We're evaluating Power BI Desktop to see if it works well with an Open Data (OData) feed. The OData feed we're working with returns 3 tables, where one of the tables has additional columns, that can be selected by adding the option "MoreColumns=true" to the Odata.Feed() call. After that a new column named "More Columns" appears, so that's fine.

However, if you then open the More Columns column, it only shows a few additional columns. It states that not all columns are showing, and you can hit 'Load more', after which it states that 'The limit of 1000 rows scanned has been reached'. So, this table contains a large number of additional columns, more than 1000. However, it doesn't show all 1000, it only shows some 30+ columns, and in a peculiar order/set. If ordered by name, it starts with some extra columns starting with 'A', then some with 'B', and then skips to 'O', so all columns we expect starting with 'C' through 'N' are not displayed.

So three issues with MoreColumns:

1. not showing all 1000+ additional columns
2. not showing first 1000 additional columns
3. showing additional columns in wrong alphabetical order

See screenshot (in Dutch) below:

[v-qiuyu-msft]

Hi @Anonymous, 

It's not the issue for OData data source , it's the limitation in Query Editor currently. You can vote on this similar idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17163812-increase-the-limit-1000-of-values-for-filtering

Based on my research, if we set the column values sort based on Name, it will sort column values based on the first character of the value. When the first character is the same, then compare other characters from left to right side within each value. 

Best Regards,
Qiuyun Yu