Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

wodraeve

PowerQuery shows "null" value in preview dropdown for SQL Views after "Load More"

Submitted by on ‎07-17-2018 01:50 PM

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!

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎07-18-2018 11:11 PM

Hi @wodraeve,

 

Do you men the Load More button like below?

 

q7.PNG

 

q8.PNG

 

Based on my test with Power BI desktop version 2.59.5135.781 64-bit (June 2018), click on Load More will not display invalid null values.

 

Which Power BI desktop version do you run? Please try the same version as ours then test again. 

Does the issue happens to all SQL views? 

 

Best Regards,
Qiuyun Yu 

 

Idea Statuses