Forum Discussion

Naresh1511's avatar
Naresh1511
New Member
2 years ago

Connectivity to Essbase as data source and future vision

Hi All,   I have read the documentation for Essbase connectivity from PowerBI as datasource in this article and have following questions as we have use cases and requriements from users. https://d...
Need Help
Show and Tell
Naresh1511's avatar
Naresh1511
New Member
2 years ago

Thanks Jing for responding. I did check the Oracle support document but they have only mentioned the changes t o client service urls. We have already updated url in the power bi connector but it does not work and would not display essbase applications under 21c. Hence wanted to check here.

 

Regards,

Naresh

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Naresh1511 

 

The latest news about Essbase connector update I found is still from this blog published in 2019 while Essbase 19c and 21c became available in 2020 and 2021, later than the blog. So I'm afraid they are not supported by the current Essbase connector. 

 

Perhaps you have to consider other alternatives, like exporting data from Essbase 19c/21c into files or databases that are supported by Power BI. If Essbase 19c/21c provide APIs for querying data, you can also consider using Web connector or Power Query Web.Contents function to query data from those APIs directly. Exporting data into files should be the easiest approach and you need to arrange a schedule refresh for updating the data in Power BI Service. 

 

Best Regards,
Jing