powerbi report server
134 TopicsPower BI Report Server Schedule Refresh Error
In the report server database est connection is successful but whenever doing schedule refresh its not connecting. throwing error like "an error occurred within the report server database. this may be due to a connection failure, timeout or low disk condition within the database. " I also looked in the logs RSPowerBI_*.log in it shows below: 2025-09-11 15:55:08.0141|ERROR|23|Couldn't find database: 3c675ff9-b931-4a61-acdb-e8924582136f_992049747 in AS server | RequestID = dbd26ec4-a393-e28d-aec7-bd03b4899692 ClientSessionID = bd46be3c-5300-83d6-2ee4-382860fcf8b3 Microsoft.PowerBI.ReportServer.AsServer.DatabaseNotFoundException: Couldn't find database: 3c675ff9-b931-4a61-acdb-e8924582136f_992049747 in AS server 2025-09-11 15:55:08.0561|ERROR|41|Unhandled error in the Web API|GET https://prd-dwh-db.bocad.ad/powerbi/api/explore/reports/3c675ff9-b931-4a61-acdb-e8924582136f/modelsAndExploration?preferReadOnlySession=true - Response Unknown| RequestID = dbd26ec4-a393-e28d-aec7-bd03b4899692 ClientSessionID = bd46be3c-5300-83d6-2ee4-382860fcf8b3 Microsoft.PowerBI.ReportServer.AsServer.DatabaseNotFoundException: Couldn't find database: 3c675ff9-b931-4a61-acdb-e8924582136f_992049747 in AS server at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.GetDatabaseOrThrow(String databaseName) at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.GetPowerBIDataSourceVersion(String databaseName) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSourcesCollection(String databaseName, TOMWrapper asWrapper) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSourcesInternal(String databaseName, TOMWrapper asWrapper) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.SetModelParametersInternal(TOMWrapper asWrapper, String databaseName, IEnumerable`1 parameters) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<LoadDatabaseForExecutionAsync>d__17.MoveNext()Solved2.3KViews0likes11CommentsPowerBİ Mobile Error "An Unexpected Error Occurred, Please try again later"
I am encountering the following warning message in the PowerBI Mobile app. After clicking the "Got it" button, the report opens successfully. This message does not prevent the report from opening, and it does not appear consistently; it only occurs intermittently. No such error appears when accessing the report via a browser. We are using the "PowerBI Report Server September 2024" version, with a clustered setup consisting of 2 servers, and we also use NLB (Network Load Balancing). The model and data are stored within PowerBI. I need your assistance with this issue .2.2KViews0likes8CommentsPowerBI report Server- Azure AD Integration
Hi, I'm trying to integrate the Azure AD with my PowerBI report Server on my Windows server. I added configuration to the ReportServer file and according to certain sources. I'm getting an error message right now. Please have a look at the error message below. 2024-08-16 05:39:35.9814|ERROR|5|Error syncing configurationSystem.NotSupportedException: Extension not supported. at Microsoft.BIServer.Configuration.ConfigReader.GetAuthenticationTypes() at Microsoft.BIServer.Configuration.ConfigReader.GetAuthenticationMode() at Microsoft.BIServer.Configuration.ConfigReader.<Init>b__57_3() at System.Lazy1.CreateValue() at System.Lazy1.LazyInitValue() at Microsoft.BIServer.RSHostingService.ServiceConfigurationManager.SyncMachineKey() at Microsoft.BIServer.RSHostingService.ServiceConfigurationManager.UpdateApplicationConfigs() Therefore, I want to know if the PowerBI report server supports Azure Authentication. If so, could you kindly share the necessary documentation?Solved2.1KViews0likes1CommentAvoid login username and password prompt for Power BI report on Report Server
Hi Team, I have a power bi report deployed on report server. And I have a Active Directory group with all users. When user click the report link to open, immeadiately prompts for login information like username and password. Users are using Chrome,Windows IE & Edge, Mozilla, safari and other browsers. Is there any way to avoid login prompt window and access power bi report directly without any authentication. The reporting setup is on-premise and consists of Power BI Report Server, has various types of PBIX files in imported mode. There is AD based authetication provisioned to all the above PBIX reports. There is no SSAS and the PBIX files are linked to SQL Server. Issue: Windows login prompt with authentication for username and password: I have defined "Data Source" with credentials by using a common user account. 1) Is there any work around to resolve this issue? 2) Is there any way to use common user login username and password for all users while opening power bi report on report server ? Kindly reply back with your inputs and suggestions. Appreciate for those. Thank you. PS: I have gone through other links for same kind of questions in the forums but couldn't get the right information about this issue. Best Regards, Maruthi SP27KViews0likes7CommentsCannot save pbix or upload pbix to report server
Hi Fresh install of an on prem PowerBI Report Server on Server 2019, its a test box for now so SQL also installed on same box (SQL 2019) I am unable to upload pbix files through the web interface, nor am i able to save them using Save As from the Desktop application. Both server and desktop client are May 2021 x64 When i try to upload using the web interface i get: There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file. When i use the desktop client and choose Save As and then choose the PowerBI Server - i input my url and at the end i get the error: An error occured while attempting to save the report to Power BI Report Server Client and Server both on same domain. Log file keeps showing a 401 unauthorised and a 404 not found every time i try a pbix file - however i can upload word and excel files just fine 2021-07-30 09:53:41.1929|INFO|55|Received request GET /api/v2.0/CatalogItems(Path='/PowerReport1.pbix')| RequestID = s_a76011a7-e009-4e31-83c7-0b0b49fb900a 2021-07-30 09:53:41.1929|ERROR|55|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/PowerReport1.pbix' cannot be found.;| RequestID = s_a76011a7-e009-4e31-83c7-0b0b49fb900a 2021-07-30 09:53:41.1929|INFO|55|Sending response. Response code domain\user 404, Elapsed time 0:00:00.0039785| RequestID = s_a76011a7-e009-4e31-83c7-0b0b49fb900a 2021-07-30 09:53:41.3336|INFO|55|Received request GET /api/v2.0/CatalogItems(Path='/PowerReport1')| RequestID = s_e3264ae6-d8e7-419f-89dc-d9544d3385b6 2021-07-30 09:53:41.3336|ERROR|55|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/PowerReport1' cannot be found.;| RequestID = s_e3264ae6-d8e7-419f-89dc-d9544d3385b6 2021-07-30 09:53:41.3336|INFO|55|Sending response. Response code domain\user 404, Elapsed time 0:00:00.0037668| RequestID = s_e3264ae6-d8e7-419f-89dc-d9544d3385b6 2021-07-30 09:53:41.7398|INFO|55|Received request GET /api/v2.0/System/Properties| RequestID = s_f2b30548-31fb-432f-9875-b47d3ab67b89 2021-07-30 09:53:41.7554|INFO|55|Sending response. Response code domain\user 200, Elapsed time 0:00:00.003992| RequestID = s_f2b30548-31fb-432f-9875-b47d3ab67b89 2021-07-30 09:53:41.9429|INFO|55|Received request GET /api/v2.0/me| RequestID = s_6e9e5018-3494-4471-9e10-09cf9f435276 2021-07-30 09:53:41.9898|INFO|55|Sending response. Response code domain\user 200, Elapsed time 0:00:00.0382069| RequestID = s_6e9e5018-3494-4471-9e10-09cf9f435276 2021-07-30 09:53:42.1304|INFO|55|Received request POST /api/v2.0/powerbireports(Path='/PowerReport1')/Model.Upload| RequestID = s_0a3fe44d-23fc-4fb7-b66d-9be5e9ab1f18 2021-07-30 09:53:42.1304|ERROR|55|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/PowerReport1' cannot be found.;| RequestID = s_0a3fe44d-23fc-4fb7-b66d-9be5e9ab1f18 2021-07-30 09:53:43.3393|ERROR|54|The remote server returned an error: (401) Unauthorized.| RequestID = s_0a3fe44d-23fc-4fb7-b66d-9be5e9ab1f18 2021-07-30 09:53:43.3393|INFO|52|Sending response. Response code domain\user 422, Elapsed time 0:00:01.2197189| RequestID = s_0a3fe44d-23fc-4fb7-b66d-9be5e9ab1f18 Ive granted my domain account full rights to the Report Server Site Settings also in Manage Folder Anybody able to offer any further help on this please? Thanks12KViews0likes16CommentsField Parameter Work Around
Good Day All I hope you can advice me on a way to use DAX to create a Field Parameter like function. I want to use a bar or column chart to display the total counts per User based on a paramter I created. I can add my Switch measure for counts on the x - axis but when I do something simular for the users it does not work when I add it to the y - axis. Every google search I do points back to the Desktop version of Field Parameters But PowerBI RS does not have that function. Data: I have one main table with all the data. In this table i have a column with a unique number that I use for counts. I have TimeStamp columns for each process of the unique number and with the TimeStamp there is a User I have duplicated the main Users table into the diffrent processes. UserAcknowledged, UserPhoned, UserCompleted. I created an index And then linked them to the Main Table on the individual UserID's, the TenantID's, and ClientID's Take Note: I have another version Where I kept the UsersTable as one table but broke up the Main table in the diffrent pressess but that increased my file size alot but I was at least able to design my chart. I created a Slicer measure that will control the counts and hopefully the users all at once (Slicer)_OperationStages = UNION( SELECTCOLUMNS( GENERATESERIES(1, 7, 1),"ID", [Value], "StageDesc", SWITCH( [Value], 1, "All", 2, "Acknowledged", 3, "Phoned", 4, "Completed", 5, "Canceled", 6, "Dispatched Stack", 7, "Dispatched") ), ROW("ID", 0, "StageDesc", "Unknown") -- Add an "Unknown" stage with ID 0 if needed ) When I create the Switch function measure for users it does not allow it to pined to the bar chart visual _Exp.Switch.All(Users) = VAR SelectedStageID = SELECTEDVALUE(('(Slicer)_OperationStages'[ID])) RETURN SWITCH ( SelectedStageID, 2, SELECTEDVALUE('dimUsers(Ack)'[Username]), 3, SELECTEDVALUE('dimUsers(Phn)'[Username]), 4, SELECTEDVALUE('dimUsers(Com)'[Username]), 5, SELECTEDVALUE('dimUsers(Can)'[Username]), 7, SELECTEDVALUE('dimUsers(Disp)'[Username]), BLANK() -- Return blank if no selection or unexpected ID ) Is there any advice that someone can provide to help me.Solved2.2KViews0likes5CommentsEmbed power bi report server authentication
I have an on-prem power bi report server and want to embed the dashboard using iframe but I'm facing a problem where the Windows logon popup appears and the user is not in my domain. how can I pass the authentication through the iframe3.2KViews0likes8Comments