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
