Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi All,
i have analyzed about this and identified that currently Oracle Hyperion not support ODBC based data extraction.
Hi All,
i have analyzed about this and identified that currently Oracle Hyperion not support ODBC based data extraction.
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