Forum Discussion
"Attempted to read or write protected memory" error when connecting to SAP HANA
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
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.
Hi Lydia,
IT have checked my computer and confirmed I had 64 bit driver. They also installed it again. But the problem is still there. Another odd thing about the problem is that it happens randomly. It happened in both Direct Query and Import modes the other day, but it only happened in Import mode yesterday. My colleague also had this problem ocurring randomly.
Anonymous,
Please open a support ticket in Power BI support site.
Regards,
Lydia