I made a successful connection to a local MSSQL Database where there are no spatial tables (only datatables).
I list the tables/views in the database (clicking on "Also list tables with no geometry" checkbox).
Some tables add to my workspace but I can only see one record for each table. This is the case with 75% of table/views. In table view it says it is filtered but I see no visible filter in layer properties. Besides, it always shows just the last record of the table/view.
Some other tables can't be loaded (although they have primary key in SQL Server) and I only get "It's not a valid layer" mesage.
The result is that I can't load any table from MSSQL properly...
I am in QGIS 3.2.2