https
20 TopicsError to connect Power BI App using HTTPS on PowerBI Report Server
Hello guys, I deployed the Power BI Report server using a HTTPS certificate signed by the root certificate of my organization and I am not being able to conect the Power BI app on it using the HTTPS portal. Some facts: - I Installed the root certificate on the mobile device, so no HTTPS warnings - I can access the Power BI Reporting Services with my mobile device using the browser - If I go to the Power BI Reporting Services Configuration and set up an HTTP portal, I can use it with the mobile normally - I tested in 2 different devices and 2 different servers with the last version of Power BI Report Server Is someone else having problems to connect the PowerBI App to a PowerBI Report Server with HTTPS?8.4KViews0likes10CommentsPower BI Report Server 404 Not Found after removing HTTP URL Reservation
Hi, I have been asked to remove possibility to access report via HTTP on Report Server. I have removed reservations for address REPORTServerURL.COMPANY.COM and just leave REPORTServerURL.COMPANY.COM on HTTPS Section. But after that whenever I try to access Power BI Reports on report server (open it or try to Manage it) i am getting generic Error on Browser. Inside the LOG file i can find : 2021-06-11 12:59:13.4679|ERROR|6|OData exception occurred: System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse() at Microsoft.ReportingServices.Portal.ODataWebApi.Utils.PbixReportHelper.ShouldReShred(PowerBIReport entity, Uri basePortalUrl, ILogger logger, IPrincipal userPrincipal, String reportServerHostName) at Microsoft.ReportingServices.Portal.ODataWebApi.Common.CatalogItemControllerHelper`1.GetItem(String key) at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.GetEntity(String key, String castName) at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.GetRoot(ODataPath oDataPath, Int32& index) at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c_DisplayClass6_2.<GetExecutor>b2(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d_6.MoveNext().| RequestID = s_b51b9bce-3f3e-46aa-8c9b-d184f31c865d7.1KViews0likes5CommentsHow to change http to https redirect in local sever
Hi, I have task to convert url power bi report server from http to https. I have done all steps I change the configuration https from " Report Server Configuration Manager" like this way also, after that i got this " Warning: Potential Security Risk Ahead " Now, how to solve that issue and how to create certificate request ?Solved6.8KViews0likes5CommentsHTTPS PowerBI Report Server to HTTP SQL Server data source - error 401
I have just experienced a bizarre problem today. My PowerBI report server (on prem) was previously on a self cert SSL before. I have reports that runs on Imported mode from a remote SQL Server which doesnt accept encrypted connection. All within the same domain. I have upgraded the SSL to a SAN SSL the other day on the report server. All the data source connection remain the same (non SSL remote SQL Server). BTW I am running May 2021 report server. This morning one of the colleagues reported that the data wasnt refreshed. Upon checking I saw the schedule refresh failed. And I tried to add refresh schedule on another Import mode PBIX report. Got a big fat "Something went wrong". Data source have basic credentials and on the data source page test connection is successful with the basic SQL login credentials.But whenever I try to add a refresh schedule i get the same error. Went on checking log and verbose. Got "Error 401". Detail error, if anyone is interested: 2021-07-07 00:47:55.7026|ERROR|63|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass136_0.b__0() at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper1.ExecuteMethod(Boolean setConnectionProtocol) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.CreateCacheRefreshPlan(String itemPath, String description, String eventType, String matchData, ParameterValue[] parameters) at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass19_0.<CreateCacheRefreshPlan>b__0() at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func1 func) at Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.CreateCacheRefreshPlan(IPrincipal userPrincipal, CacheRefreshPlan cacherefreshPlan) at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CacheRefreshPlansController.AddEntity(CacheRefreshPlan entity) at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController1.Post(ODataPath oDataPath, T value) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.d__6.MoveNext().| RequestID = s_9b953a1c-bc48-41f3-ad5b-12e903990663 By now I may have read 95% of the forums/blogs/solutions/documentations without luck. So I thought, lets try to do it over HTTP (port 80) instead of HTTPS (port 443). And it worked like a charm. BTW, by default HTTP binding is removed, only HTTPS is allowed. I have checked "Encrypted connection is disabled" in the datasource settings in PowerBI desktop and refresh+redeployed. Same issue over HTTPS but works fine on HTTP. Does anyone have a permanent solution/fix to this problem? Because running report server on HTTP is not allowed. I have tried restarting both instances, changing reg values mentioned on the internet, nothing worked. Additionally we have kerberos enabled, and our windows authentication works perfeclty fine for remote SQL Server datasources. Thank you all for reading and using your brain space. Have a good night. Note: the forum removed some parts of the error message. It doesnt let me submit them.Solved5.2KViews0likes4CommentsServer Is Not Reachable over HTTPS
I'm currently getting a 'Server is not reachable' error when attempting to connect to Power BI Report Server via Power BI desktop over HTTPS or trying to Edit in Power BI desktop from the web portal. I'm on September 2022 right now, but I was also experiencing this issue on May 2022. I can upload via the web portal interface, but I would like to get this piece working from Power BI Desktop. What's strange to me is that I AM able to connect over HTTP with no issues. There are no blocks within the Firewall or other security programs. Anyone have any suggestions? I saw a few posts on here with similar issues but didn't seem to be much resolution.Solved3.7KViews0likes4CommentsUnable to Login to Report Server with HTTPS & SSL
Hello everyone, I am currently running an on-premise Power BI Report Server and am trying to enable the https on the system. I'm having difficulties trying to login to the Portal. It is stuck at the login page like forever. It has no issue login into the report when it is just using http. (the login credential has no issue, I have checked it millions of time) I am currently using a wildcard public certificate from GlobalSign (which is working for all my other webservers). The cert is not expired. And I have made sure that the DNS is configured correctly to resolve the hostname of the report server, but still was unable to make it through the login page. When I log in, it keeps coming back to the login page. Does anyone face this scenario before? It would be really helpful if you can provide a step by step guide solution to this. Thanks Regards Mark Teh3.6KViews0likes3CommentsSave Report to Secure (HTTPS) Server
While trying to save a report from Power BI Desktop (May 2019) to our Report Server instance I am getting an Error: Unexpected Error message. Our Report Server URL is along the line of https://test.bi-reports/rs-bi/reports and as near as I can tell the save function is falling over on trying to authenticate on the server to complete the action. Looking at the RSPortal log on the Repot Server there is a message |Sending response. Response code NT AUTHORITY\ANONYMOUS LOGON 422,3.3KViews0likes10CommentsSave as via HTTPS: Server is not reachable
Hi all, in our organisation we have private cloud where we are hosting 2 Report Servers: RnD and Production. RnD is reachable via HTTP and Production is reachable via HTTPS. Each server has its own private network. For production server we have certificate installed and Kerberos is working. All users can access both server. PBIX reports work fine on the server Using "Upload" button from portal we can deploy PBIX files from our machines on both servers but only on HTTP (RnD server) we can use "Save As" option in Power BI Desktop (Version: 2.51.4885.1423 64-bit (October 2017)) to deploy reports. When we specify url for PRODUCTION server (HTTPS) we have "Server is not reachable" message. Does HTTPS Save As option works on specific PORT that we need to open in firewall on our private network? Or it is something else? Thanks in advance. Dejan2.8KViews0likes4Comments