Forum Discussion

_Abhilash's avatar
_Abhilash
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

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.