503 errors with custom visuals with report server using form authentication
Hi. In the last 2 months I have problems with using custom visuals (of the marketplace) in PBI reports on my report server using custom authentation (I use Forms authentication). The 503 error is quite random and might not happen everytime, but can be reproduced by hitting F5 in the browser. Sometimes all custom visual are ommited, sometimes only a part of the custom visuals are drawn - sometimes a scrollbar is shown on the custom visual, but there should be no scrollbar (e.g. the tag cloud visual). It's a very random error/problem. Here is a small example from the Edge console window: GET https://my.server.com/powerbi/libs/scripts/customVisualsHost.bundle.js net::ERR_ABORTED 503 cvSandboxMinimal.htm:16 GET https://my.server.com/powerbi/libs/scripts/visualSandbox.minimal.externals.js net::ERR_ABORTED 503 cvSandboxMinimal.htm?=&plugin=tagCloud8448D0BE3AE3424D97B3973515418218&locale=de-DE:17 GET https://my.server.com/powerbi/libs/scripts/customVisualsHost.bundle.js net::ERR_ABORTED 503 cvSandboxMinimal.htm?=&plugin=tagCloud8448D0BE3AE3424D97B3973515418218&locale=de-DE:7 GET https://my.server.com/powerbi/libs/styles/visualsandbox.css net::ERR_ABORTED 503 cvSandboxMinimal.htm?=&plugin=tagCloud8448D0BE3AE3424D97B3973515418218&locale=de-DE:16 GET https://my.server.com/powerbi/libs/scripts/visualSandbox.minimal.externals.js net::ERR_ABORTED 503 cvSandboxMinimal.htm?=&plugin=htmlContent443BE3AD55E043BF878BED274D3A6855&locale=de-DE:7 GET https://my.server.com/powerbi/libs/styles/visualsandbox.css net::ERR_ABORTED 503 The problem happens on all major browser in their current version. The Report Server runs the January 2021 release, but the problem showed up with the release before (October 2020 - most current version), too. Has anybody seen this odd behavior - and is there a solution/workaround for this 503 problem? Thanks, Lars
reportserver error after 2023-May update (custom authentication)
Hello, Last week we upgraded from 2021-Sep to 2023-May. Previously, when accessing the bi portal using custom authentication, the following url was used. https://domain_name/ReportServer/logon.aspx?ReturnUrl=/ReportServer/localredirect?url=%252freports%252f But after update, the following error occurs when connecting to bi portal home. webserver!ReportServer_0-3!74f0!07/10/2023-09:00:52:: e ERROR: RS.Server.HttpHandlerError {"shortHttpDescription":"Server Error","code":"500","path":"reportServiceHandlerWriteError","exceptionType":"Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException"} runningrequests!ReportServer_0-3!9f14!07/10/2023-09:02:08:: w WARN: localredirect has been rejected as redirect URL does not point to registered local directory! URL: /reports library!ReportServer_0-3!9f14!07/10/2023-09:02:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at Microsoft.ReportingServices.WebServer.Global.DispatchRequest() at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e) --- End of inner exception stack trace ---; webserver!ReportServer_0-3!9f14!07/10/2023-09:02:08:: e ERROR: RS.Server.HttpHandlerError {"shortHttpDescription":"Server Error","code":"500","path":"reportServiceHandlerWriteError","exceptionType":"Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException"} As an interim measure we eliminated url encoding and changed url setting as below and we could connect bi portal. But the rs:embed=true option is not working properly and specific folder open is not possible now. https://Domain Name/ReportServer/logon.aspx?ReturnUrl=/reports/ It's been too long since the 2021-sep version, and it seems that there have been changes in url processing. Please help us in what part to take action.
RLS and Custom Authentication
Hi all, We actually have an issue with the Row Level Security and a custom authentication system (CAS). How can you assign a role to a user or a group if the CAS do not use the Active Directory used for the Power BI installation ? Is there a way to affect all user to a role ? (I tried "Authenticated Users" and it doesn't work) Regards,
Technical Advice - Power BI on-premise report server - custom authentication
Hi, I'm looking for a technical advice, I'm trying to achieve the following: - Building an internet facing system that displays Power BI dashboards - SQL membership forms authentication (already achieved following this sample (https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample) - On-Premise Power BI report server - direct query to SQL - pass logged in user (form authentication credential) to SQL - I guess we can achieve row-level-security if we used "import" mode instead of "direct query" mode - in case of connection to SSAS, can I pass form authentication credential to SSAS and apply row-level-security Thank you, Ayman
Error in refreshing Power BI report based off OData connection in Custom authentication mode
I am unable to refreseh Power BI Reports based off OData service uploaded in PBI RS which used custom authentication. Following are the logs from RSPowerBI 2018-03-23 16:11:02.2304|INFO|6|Handling event with data: TimeEntered: 3/23/2018 11:11:00 PM, Type: Event, SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, EventType: DataModelRefresh 2018-03-23 16:11:02.3954|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Data Refresh. 2018-03-23 16:11:02.4164|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Retrieving PBIX AsDatabaseInfo. 2018-03-23 16:11:02.4503|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Verifying all the data sources are embedded. 2018-03-23 16:11:02.4503|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Verifying connection strings are valid. 2018-03-23 16:11:02.4582|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Streaming model to Analysis Server. 2018-03-23 16:11:02.4860|ERROR|6|Error Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Error Failed Streaming model to Analysis Server, Exception System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.ArgumentNullException: Value cannot be null. Parameter name: s at System.IO.StringReader..ctor(String s) at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options) at Microsoft.ReportingServices.CatalogAccess.PolicyAcessor.<GetItemPolicies>d__3.MoveNext() --- End of inner exception stack trace --- at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification) at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.<LoadDatabase>d__10.MoveNext() --- End of inner exception stack trace --- at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.LoadModel(AsDatabaseInfo asDatabaseInfo) at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7() at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext() ---> (Inner Exception #0) System.AggregateException: One or more errors occurred. ---> System.ArgumentNullException: Value cannot be null. Parameter name: s at System.IO.StringReader..ctor(String s) at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options) at Microsoft.ReportingServices.CatalogAccess.PolicyAcessor.<GetItemPolicies>d__3.MoveNext() --- End of inner exception stack trace --- at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification) at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.<LoadDatabase>d__10.MoveNext() ---> (Inner Exception #0) System.ArgumentNullException: Value cannot be null. Parameter name: s at System.IO.StringReader..ctor(String s) at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options) at Microsoft.ReportingServices.CatalogAccess.PolicyAcessor.<GetItemPolicies>d__3.MoveNext()<--- <--- 2018-03-23 16:11:02.5050|ERROR|6|Error Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Error Failed Data Refresh, Exception System.ArgumentNullException: Value cannot be null. Parameter name: s at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry) at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo) at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7() at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext() I could run SQL trace and it looks like the issue is with calling SPs with wrong AuthType value exec GetCatalogItemProperties @CatalogItemID=N'54c2330e-9b69-4bdd-a3d0-8c6a18b15e1f' --PBI RS code makes this call exec GetPolicyByItemId @ItemId='54C2330E-9B69-4BDD-A3D0-8C6A18B15E1F',@AuthType=1 --I am assuming it should be making this call with @AuthType=3 exec GetPolicyByItemId @ItemId='54C2330E-9B69-4BDD-A3D0-8C6A18B15E1F',@AuthType=3Manage security and RLS with custom authentication
Hello everybody, I am a bit new in Power BI Report Server. I installed my evaluation trial and configured with reports and Windows users fine. Then I needed to use custom authentication, so I tried to get it as explained in https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample#start-of-content and in the end it worked fine. I created clicking on "Register new user" of login window, then I added it in Security element in RSReportServer.config file (step 3 of the article) and finally I could login. When I am in the Report Server, I see reports, I can manage security on first page and choosing Element roles and System roles, but a lot of things are not working as it always tells me "An error occurred. Try later": I can't open the Menu of any report, where I could manage RLS, updates, title and so on clicking on right-upper corner I can't open any report I can manage Element and Security roles but they look not to work as I gave me Content Manager and System Administrator but I can't edit anything about reports. I don't see previous domain users anymore but maybe it's normal, but I need to configure many users and giving them permissions about folders and reports but it doesn't work. Some particular aspects which could be useful: In Report Server Configuration Manager, as Service Account I use a domain account of my server which I used before to login to Report Server too, maybe I should change? I don't know but I don't think In step 4 of the article to configure custom authentication you need to generate machine key with Validation="AES" but when I generated it with my server I got Validation="HMACSHA256" Please help me because I really need to configure it in the right way, it's very important to me. Thanks a lot NickCan't edit datasource in PBIRS with custom authentication
Hi all, I have set up a server with PBIRS Jan2020 and custom authentication following the github pages indications. I can connect to the server using the forms authentication and everything seems to work fine. Main problem comes when i upload a PBI Report to the server with a SSAS live connection, i can't edit the datasource in the management tab of the report, the option datasource is disabled so i can't change the user and password to connect to ssas. On the other hands, with default windows authentication works without any issue. I tried uploading the report with the PBI Desktop > Save As > Report Server option and uploading manually the report to the server and in both cases i can't edit the datasource. In the server logs i found this line: Failed to get connection string for model | RequestID = 29a6f4bd-a6ce-28a6-0b07-59a3380b4db6 ClientSessionID = 35485d15-aa30-e08e-e29b-af7bb15732c1 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model Any clues? Thanks and regardsReport Server with Forms Authentication always redirect to Logon.aspx
Hi everyone, I have on premise installation of PowerBI 2020, used with Forms Authentication., with all setups decribed in the article. Whenever I am trying to open Reports page, I am always redirected to Logon.aspx in an infinite loop. The forms cookie is there, whenever I hit the logon.aspx page the user is authenticated (I can debug it). The ReportServer page, however, is shown without problems. Does anyone know how it can be fixed? Thank you.
Report server custom Authentication & Embed Url
I have configured custom authentication for power bi reporting services and copied the url of a report uploaded into the reporting services and embed it in our application in an iframe.But when I login with a report server configured user in my application and when I access the page, I get the custom authentication login page instead of logging directly into report. Any suggestions would be really helpful.
