Forum Discussion

tsakoc's avatar
tsakoc
Frequent Visitor
7 years ago

Data import limit when using ODBC connection

When I try to import a table with 162 million rows using a ODBC connection it limits the import to 54 million rows. However when I import the table using a SQL connection a full import with 162 milli...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi tsakoc ,

 

There are two solutions you can try.

 

The first solution, you can change the source from import in the advanced editor, and there is a similar case.

The second solution, you can choose the “Supported row reduction clauses” option like picture below, click the Detect button and it will select one for you. For the better performance, recommend you not import all 162 million rows data .

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You can learn more: https://blog.crossjoin.co.uk/2019/01/04/odbc-power-bi-power-query-refresh-performance/

                                       https://docs.microsoft.com/en-us/power-query/odbc%C2%A0

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

                            

Best Regards,

Amy

 

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