Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

"Attempted to read or write protected memory" error when connecting to SAP HANA

Hi,   After the upgrading Power BI from Feb 2018 to Aug 2018, Query Editor cannot show SAP HANA cube preview anymore. My colleagues and I got an error message "Attempted to read or write protexted ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

What bit version of Aug 2018 Power BI Desktop do you use, 64 bit or 32 bit? I am using 64 bit version of Power BI Desktop to connect to SAP hana and everything is well. The ODBC driver version I installed is also 64 bit. You can perform the direct upgrade, no need to uninstall the previous version to check the ODBC driver version.



Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Thank you for your reply. It seems 64/32 is the problem. Although I found sap\hdbclient folder under C:\Program Files, the help file indicates the driver is 32 bit version. It states "The SAP HANA ODBO driver you need for 32-bit applications", which probably explains why my 32bit Excel had no problem connecting to SAP HANA. I will ask our IT to install 64 bit driver and see if it solves the problem.