Direct Query Not Returning All Rows

[Budfudder]

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 only.  All my visuals, etc., act only on 34,000 rows.

What am I doing wrong?

[v-jiascu-msft]

Hi @Budfudder,

Could you mark the proper answer as a solution please?

Best Regards,

Dale

[v-jiascu-msft]

Hi @Budfudder,

One more tip: duplicates will only show up once.

Best Regards,

Dale

[Seward12533 · Accepted solution]

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.