Problem to import data using ODBC 32bit

[beno]

Hi,

I receive the following error message each time I try to refresh data using an ODBC 32bit:

Failed to save modificcaitons to the Server. Error returned: 'The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version fo the product, consider upgrading to the 64bit version or increasing the amount of memory available on the machine. '.

In fact, I am using the Power BI 32bit because of my restriciton to use an ODBC 32bit for the database. Thus, I have asked the administrator to add memory, and it is now 8 GB( dual 2.4 GHz , Windows 7 Prof), but the error is always still there.

For your infomation, I have imported 2 big "fact" tables: (300'000 rows and 40'000 rows) and the other "Dim" tables are very small ( I have no idea to add conditons on table importation from the source).

I hope that I have classified this message under the right section.

Many thanks for your support.

[ankitpatira · Accepted solution]

@beno This seems more of ODBC issue than power bi desktop. i have no issues in importing more than 40K rows in power bi desktop. you should test ODBC driver out of power bi desktop and query to ensure it is able to handle that many number of rows first.

[beno]

Thanks Ankit Patira!

I have configured an ODBC 64bit, reinstalled Power BI as 64bit, and it is just went very well.

Best Regards,