Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |