cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Problem to import data using ODBC 32bit

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.

 

 

1 ACCEPTED SOLUTION
Community Champion
Community Champion

 

@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.

 

View solution in original post

2 REPLIES 2
Community Champion
Community Champion

 

@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.

 

View solution in original post

Thanks Ankit Patira!

 

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

 

Best Regards,

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors