Power BI desktop - Data Loading issue with query

[prasa]

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 it takes long time to load them. Did anyone face this situation before? Is it because of the large data set? How to load these number of rows in optimized way?

Thanks in advance. 

[v-chuncz-msft · Accepted solution]

@prasa,

You may try Use DirectQuery in Power BI Desktop.

[prasa]

Great!Thanks. I will try this option.