Power BI desktop - Data Loading issue with query

I have data table created with the Get Data -- Blank Query -- advanced editor and pasted the SQL query which should return 190k rows. But in power BI it just loads 4300 rows for that data table and i...