Rows not loading

[dixus]

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

[dixus · Accepted solution]

The problem was an error in a subquery (sort by was wrong). I think that different execution plans ran into that different outputs. Depending on the conditions.

[Idrissshatila]

Hello @dixus ,

what's the column type that has the id?

[dixus]

@Idrissshatila this is an integer

[Idrissshatila]

@dixus ,

are you getting this column in power query, and if yes can you show it?

[dixus]

@Idrissshatila yes the column is there..

[dixus]

Further investigations show that this is not a power query issue. I could reproduce that weird behavior in SQL Server Management Studio:

I know that's a bit offtopic. But are here database experts too that can explain, how this is possible?