I have a report that runs in the BI Portal but uses SQL pass...

[Debra Waybright]

For those, like me, who are curious to a fault, heres what was wrong with the SQL query it had a left outer join where it should have had an inner join. The row count difference is about 71,000 vs 2,370,000.

Deb