Forum Discussion
how to connect Hyperion Essbase through ODBC
Hi friends,
is there any way to connect Hyperion Essbase through ODBC in Power BI ?
how to get and install Hyperion Essbase ODBC driver in windows ?
Hyerion Essbase details:
hyperion server- http://host:port/aps/Essbase
Service account username -xxxxxx
Password-XXXXX
appriciate your suggestions.
4 Replies
HI Anonymous,
For creating odbc driver, you can refer to the following document:
BTW, current power bi already provides the Essbase connector on the desktop side, why not try this one to get data from your database?
Power BI - steps to connect Essbase using Essbase Connector (beta)
Regards,
Xiaoxin Sheng
Hi v-shex-msft,
am trying to create dataflow with Hyperion based ODBC based gateway. So am plannig to install ODBC drivers on gateway server. but i did not find any way to the setup of ODBC.
Hi Anonymous,
AFAIK, odbc connector also availed on power bi dataflows.
You need to install the driver on the gateway server and make sure it can access to the remote data source. Which steps did you confuse to finish these configurations?
Installing and Configuring an ODBC Driver in Windows 10 (32 / 64-bit)
Regards,
Xiaoxin Sheng