Forum Discussion
Challenge: Can Essbase Directly Access SharePoint as a Source?
Hi mm5308 ,
Based on your description, you are trying to build a Power BI solution that requires the Essbase connector to directly reference data from an Excel file on SharePoint that is used to build MDX statements as part of an Essbase query. I noticed that you have tried a few steps while in power bi desktop that have worked.
You might consider using an intermediate database to store the Excel data and then have Essbase fetch the data directly from the intermediate database. This way, the Essbase query is not directly dependent on the Excel data source in Power BI.
Alternatively, import the Excel data into Power BI and publish it as a dataset, and then Essbase can fetch the data through the Power BI dataset.
You can try these two approaches to see if they meet your requirements
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous,
Thanks for your suggestions. Unfortunately, I have read-only access to Essbase and no server space to perform data pulls and serve as intermediary. Neither of those approaches will work in this case.