Data extraction from a single SQL Server table into Power BI using the import method is very slow

Hi RAVI20035 ,

As mentioned lbendlin  earlier, having many wide nvarchar columns, especially nvarchar or other large sized fields, can significantly slow down data transfer between SQL Server and Power BI.

To enhance performance, consider these best practices.

1. Import only necessary columns to reduce data volume.

2. Exclude or trim large text fields like nvarchar unless absolutely necessary.

3. Apply filters at the source using SQL views or Power Query to limit both rows and columns before loading into Power BI.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.