Forum Discussion

Budfudder's avatar
Budfudder
Helper IV
8 years ago
Solved

Direct Query Not Returning All Rows

I'm betting there's something I don't know here. I am loading a table using an SQL statement, using Direct Query. The table has over 180,000 rows - but no matter what I do, it returns 34,000 rows onl...
Need Help
  • Seward12533's avatar
    Seward12533
    8 years ago

    Have you checked to see if any of your records are returning errors. What do you see if you look in the Table View of PowerBI? Does it only hve the 34000 there? You can also write a measure to check TotalRows = COUNTROWS(table).  You can check in PowerQuery by selecting your query and choose KEEPERRORS, shoudl return a blank result if there are no errors.  

     

    If that isn't the issues your measures may be returning NULL so nothing will be displayed. 

     

    Another option is your have bridge table that does not have all the values in it and it will force the filter context down into the tables and effectively ignore anything that does not bridge between the two.  A Pic of your Data Model to see how the tables are related as well as what measures you using etc.. will really help us help you. 

Seward12533's avatar
Seward12533
Solution Sage
8 years ago

Have you checked to see if any of your records are returning errors. What do you see if you look in the Table View of PowerBI? Does it only hve the 34000 there? You can also write a measure to check TotalRows = COUNTROWS(table).  You can check in PowerQuery by selecting your query and choose KEEPERRORS, shoudl return a blank result if there are no errors.  

 

If that isn't the issues your measures may be returning NULL so nothing will be displayed. 

 

Another option is your have bridge table that does not have all the values in it and it will force the filter context down into the tables and effectively ignore anything that does not bridge between the two.  A Pic of your Data Model to see how the tables are related as well as what measures you using etc.. will really help us help you.