Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there, I need your opinion 🙂
I have to do reporting on some data available in a SAP HANA cloud database in my PBI Desktop, and then publish the report to the PBI service.
Two options to get the data are available, the first through Hana Connector and the second via ODBC connector. ( Hana client already installed )
The question/concerns I'm having is as follow :
We went with the ODBC connector, and now a gateway needs to be set on both the Hana platform and the PBI Service, so the data refresh can be enabled ( refresh should occurs 3 times per year ). This set up looks like much efforts..
According to you, What are the risks/cons of choosing this solution ( "ODBC connector with gateway" - I see a lot of maintenance that needs to be done.. ) vs the Hana Connector ?
Looking forward to read you
Solved! Go to Solution.
Hi @Vrykolakas ,
If the database used does not have a specific connector in power bi, we would recommend using ODBC, and if the database used has a specific connector in power bi, it is recommended to use a specific connector, because it is created specifically for the database.
This is about some support functions of SAP HANA Database:
This is the related document, you can view this content:
https://www.biconnector.com/blog/how-does-biconnector-compare-to-native-odbc-driver/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Vrykolakas ,
If the database used does not have a specific connector in power bi, we would recommend using ODBC, and if the database used has a specific connector in power bi, it is recommended to use a specific connector, because it is created specifically for the database.
This is about some support functions of SAP HANA Database:
This is the related document, you can view this content:
https://www.biconnector.com/blog/how-does-biconnector-compare-to-native-odbc-driver/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.