loading 110000000 rows in sql db to Power bi

[_Abhilash]

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 improve data load

Regards

[v-yingjl]

Hi @_Abhilash ,

If you have done some transformations for all these rows in Power Query Editor, it needs to call the whole table for each step query, you can try to buffer the whole table and then do the transformations for it.

See: 

1. Nested functions and Table.Buffer() 
2. How does Table.Buffer work? | Power Query | Excel Forum 

If you only connect to the sql db and import the table directly, you can try to use Direct Query mode to connect to it or try like an index columns for it like Greg mentioned.

See:

1. When is DirectQuery useful? 
2. Use DirectQuery in Power BI Desktop 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@_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