Forum Discussion
Solved
Same exact SQL query returns 0 rows in Power BI
This is a new one. Very simple SQL query returns 0 rows in Power BI. I have literally copied and pasted the query directly from SQL. And no, I am not drunk.
Very strange. I used ODBC as the data source and it worked fine. Maybe it isn't returning all rows? The particular values (i.e. "True") aren't even showing as available values when I filter the column. There are only about 9 rows (out of hundreds of thousands) that meet this criteria.
Anyway, moving on.
Very strange. I used ODBC as the data source and it worked fine. Maybe it isn't returning all rows? The particular values (i.e. "True") aren't even showing as available values when I filter the column. There are only about 9 rows (out of hundreds of thousands) that meet this criteria.
Anyway, moving on.