Rows not loading

Hello,

i hope somebody can explain that behavior or help me to understand what is going on here.

1. I got a view in azure sql server:

This is the prove that there are rows with id 9952.

2. Now switching to Power Query Editor in PowerBI and loading the view:

Filtering by id returns now an empty table. The rows are missing that are in the view (as shown above).

Now it's getting more weirdo:

using a where statement in the query in the query returns the rows. 

So why are the rows not included in the dataset when loading all rows? What is this? Am I missing something?
Haven't seen that behavior ever before.

Thank you!
HK

PS: updated to the newest PB Desktop version