Data import limit when using ODBC connection

[tsakoc]

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 million rows is executed. Is there any limit to the number of rows which can be imported with ODBC connection. I have tried this in Desktop and Service

[v-xicai]

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.