How to connect Microsoft PowerBI Desktop 2.6 to Vo...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Open the ODBC Data Source Administration for 64bit drivers and add the Simba ODBC driver
Enter the hostname of where the Vora Thriftserver service is running. The default port is 19123 unless it has been overridden in the Vora-Manager UI.
Authenticate with “Username” only and leave the username field blank
In Advanced Options set checkmark “Get Tables With Query”
In Server Side Properties add the key-value pair:
spark.vora.hive_emulation=true
In Microsoft PowerBI select “Get data” -> ODBC driver
From the dropdown list select the ODBC driver that was added in step 2
Expand the hierarchy ODBC -> Spark -> Default
Please note: In order for Vora in-memory tables to be visible they must first be registered using the command REGISTER TABLE <tableName> using com.sap.spark.vora via Vora Tools or Beeline