Issue: Power Query preview window values dropdown shows "null" when selecting "Load More" when connecting to a SQL View
How to trigger:
On SQL Server, we have a view selecting a limited set of an underlying table, eg through a TOP 1000 FROM with an ORDER BY
This view is also used by other systems so it is not a solution to shift this logic to PQ.
When connecting to the view, the dropdown for a field shows, as expected, only a limited number of values, and shows the load more option.
When clicking the "load more" button, instead of showing all the values, it shows "null".
"null" is NOT part of the actual view result, but it is part of the original table on which the view is built.
Additional info:
this behaviour does not happen in Excel!
on:
URL is not filtering on field parameter