Forum Discussion
Sap hana Database Connection
Hi team,
I have Issues in while using the sap hana database.
what my issue is I can load data from the sap hana database but if I apply some transformation in power query editor after that data can't load to the desktop getting below mentioned error .In power query just change the data type not loading .I did some research as well not able find it. Can someone this query .
Thanks,
Thennarasu R
2 Replies
Hi Thennarasu_R
Please try to go to the Power query Editor, then go to the home and click 'refresh preview'->'refresh preview' to refresh the data.
And you can refer to the following link.
Solved: Re: DataSource.Error: Invalid column name - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Thennarasu_R,
The error references SQL_DOUBLE, which is not a standard SAP HANA SQL type. Since it appears after the Changed Type step, the conversion may be translated incorrectly by the connector or ODBC driver.
Try removing that step, then apply type changes one column at a time. Also update Power BI Desktop and the SAP HANA client and driver.
If the same data is available through SAP OData, Power BI Connector for SAP can provide an alternative to the direct HANA connection: https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.html
It exposes selected SAP services, entities, and fields through a read-only OData endpoint. Compatibility depends on the required data being available through OData.
A 30-day free trial is available.
Documentation: https://metricasoftware.com/docs/sap/
Support: https://metricasoftware.com/docs/sap/contact-support-sap/
Cheers,
Metrica Team
