SAP Hana Power BI Desktop refresh error

[Ravikumarthota]

Hi all,

I have a user, he is getting this error while try to refresh datset in his power BI desktop. But other users can refresh the dataset

Error: 

Error message is: OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed. Error appears in refreshing a well-established report or attempting to connect and create a new report.

Awaiting for reply.

Thanks,

Ravi Kumar Thota

[v-zhangti]

Hi, @Ravikumarthota 

To use SAP HANA, you must have the SAP HANA ODBC driver installed on the local client computer for the Power BI Desktop's SAP HANA data connection to work properly. You can download the SAP HANA Client tools from SAP Development Tools, which contains the necessary ODBC driver. Or you can get it from the SAP Software Download Center.

For further information, please refer to Connect to SAP HANA databases in Power BI Desktop . Do pay attention to the considerations and limitations.

There is another way to try, uninstall and reinstall Power BI desktop and try connecting again.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.