Power BI desktop with Essbase using Get data

Hi All,

I am trying to connect to Essbase using Microsoft power BI through Get data. Version of Power BI is 2.71 ( July 2019). I am trying to connect to 11.1.2.4 Essbase.

I have selected essbase from get data and in the URL provided below url.

http://server:19000/aps/XMLA  This works fine and gives me the Essbase clusters. Now i have a load balance URL which is SSL enabled. if i use the F5 URL.

https://F5/aps/XMLA it is giving me below error.

Error Message:

The request was aborted: Could not create SSL/TLS secure channel.

Stack Trace:

Microsoft.Mashup.Evaluator.Interface.ErrorException: The request was aborted: Could not create SSL/TLS secure channel. ---> Microsoft.Mashup.Engine1.Library.Web.ResponseException: The request was aborted: Could not create SSL/TLS secure channel. ---> Microsoft.Mashup.Engine1.Library.Web.ResponseException: The request was aborted: Could not create SSL/TLS secure channel. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.

   at System.Net.HttpWebRequest.GetResponse()

   at Microsoft.Mashup.Engine1.Library.Common.WrappingHttpWebRequest.WrapResponse(Func`1 getResponse)

   at Microsoft.Mashup.Engine1.Library.Common.WebRequestExtensions.TlsSniffingWebRequest.GetResponse()

   at Microsoft.Mashup.Engine1.Library.Web.Request.CreateResponse(ResourceCredentialCollection credentials)

   at Microsoft.Mashup.Engine1.Library.Web.Request.GetResponseCore(ResourceCredentialCollection credentials)

   at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)

   at Microsoft.Mashup.Engine1.Library.Web.Request.GetResponse(ResourceCredentialCollection credentials, RetryPolicy retryPolicy, AuthorizationThrowFunction authorizationFunction, Boolean tokenRefreshed)

   --- End of inner exception stack trace ---

   at Microsoft.Mashup.Engine1.Library.Web.Request.GetResponse(ResourceCredentialCollection credentials, RetryPolicy retryPolicy, AuthorizationThrowFunction authorizationFunction, Boolean tokenRefreshed)

   at Microsoft.Mashup.Engine1.Library.Essbase.EssbaseService.ExecuteRequest(String method, String request, String sourceInfo, String catalog, String cube, IList`1 restrictions)

   at Microsoft.Mashup.Engine1.Library.Essbase.EssbaseModule.EssbaseServersTableValue.<GetEnumerator>d__6.MoveNext()

   at Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext()

   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)

   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()

   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()

   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()

   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

Did anyone run into issue? how can i fix the SSL issue