Forum Discussion
loading 110000000 rows in sql db to Power bi
i have More than 110000000 rows in sql db connected power query to the table haven't done transformations. When applied close and apply load is still happening any steps i can perform to impr...
_Abhilash Are you pulling from a SQL View and does that view have a clustered column index on it? Also, if you don't need all of the columns in the table then remove them from the view. Columnstore indexes: Overview - SQL Server | Microsoft Docs