Performance issue while pull the large volume of data from SQL Server

[vinothkumar1990]

Hi,

  I have a table with 5.5 M of data. I have written the simple select statement with only required columns. However, Power BI takes 1+ hr to pull the data. Is there anyway to reduce the load time?

Note: I have turned off the Date/Time intelligence and set the privary setting to ignore always.

Thanks,

Vinoth

[watkinnc]

I bet that database table is not indexed. Power Query can't fix that!

--Nate

[v-deddai1-msft]

Hi @vinothkumar1990 ,

I suggest you use direct query instead of import mode.  As data is not imported into Power BI model in this case. But there is a 1 million row limit for returning data when using DirectQuery, you can get more details in this article. 

In import mode, I would recommend you create a view to aggregate the data you need and import the view to Power BI, and you can take a look at the following blog about other best practices.https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai