cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pmacdonaldii
Frequent Visitor

How to setup Essbase connector in Data Gateway

We have setup Essbase in Power BI Desktop just fine.  I am trying to create an Essbase connection for the Data Gateway. I have tried several different formats for the server and it always errors on the test.

 

The connection configuration on the Gateway is very different than the Power BI desktop.

 

Thanks,

Peter

5 REPLIES 5
venal Solution Sage
Solution Sage

Re: How to setup Essbase connector in Data Gateway

@pmacdonaldii 

Please use the server, credentials as you used it in Power BI Desktop.

If you have any error message while configuring the data source, please share us the screenshot.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

pmacdonaldii
Frequent Visitor

Re: How to setup Essbase connector in Data Gateway

That is the issue I believe.  In Desktop there are 4 parameters to insert to be able to connect.  In the Data Gateway, there are only 2.

 

EssBase Desktop.pngEssBase Gateway.png

venal Solution Sage
Solution Sage

Re: How to setup Essbase connector in Data Gateway

@pmacdonaldii 

Thanks for sharing the screenshots.

Please configure the datasource using the servername from the Desktop, others are optional.

 

ServerName, UserName and Password - Required.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

pmacdonaldii
Frequent Visitor

Re: How to setup Essbase connector in Data Gateway

I actually did that before posting.  I have run through both configuration combinations.  Any other thoughts?  Not being able to specify the application I am wondering if Essbase is not letting it connect to the server.

pmacdonaldii
Frequent Visitor

Re: How to setup Essbase connector in Data Gateway

Finally, I got it to work.  It required the web address to work.  I thought I had tried it previously.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.