bug

54 Topics

BUG report
Is the button slicer bug in PBIRS so obvious that Microsoft can't see it? Has the quality of Microsoft engineers' work deteriorated to this extent? This is the display in design mode: This is the display in runtime: In design mode, multi-selection does not require holding the Ctrl key, while in runtime, selections cannot be made without pressing Ctrl. Additionally, the new card images are not displaying properly on mobile devices. I strongly urge Microsoft engineers to conduct thorough testing.
WithwindOK
6 months ago Place Report Server
879Views
0likes
5Comments
GCC Power BI App Search Bar Bug
Hello, I am encountering what I believe to be a bug on my power bi app in app.powerbigov.us. The search bar isn't clickable on some of my apps, and if it is clickable, the search doesn't work correctly. Has anyone else encountered this in the gcc environment?
Solved
hollytrojan
1 year ago Place Report Server
1.2KViews
1like
5Comments
Power BI Report Server January 2025 bug
I installed server January 2025 version. After install publisher role and content manager don't have manage privileges to file.
Solved
TomOm
1 year ago Place Report Server
8.3KViews
5likes
18Comments
Bug in document structure after updating to the latest May 2025 patch
Hi there, after updating the Power BI Report Server to the latest patch from May 2025, the menu items in the left document map of published classic SSRS reports can no longer be expanded or collapsed using the small plus sign. Maybe this issue is affecting other users? I would like to submit it as a bug report. Thanks for your help.
Solved
Hermann1518
1 year ago Place Report Server
1.3KViews
1like
2Comments
Availability SSRS 2022 Bug fixes
Hi Team, I am curious to know whether all the bug fixes related to rdl files design and rendering which is released in Sql server reporting services are also fixed in PowerBI report server
Solved
VMSSanthosh
1 year ago Place Report Server
1.3KViews
0likes
4Comments
Working with DATATBALE in Query View! Is this some kind of bug or am I doing something wrong?
I was playing around with the Query View in Power BI Desktop. I wanted to create a table from scratch without importing from any source and then I wanted to show output of the table also perform some calculations on it later. I thought of using Table Constructor first but as it doesn't allow to give names to the columns directly so I used DATATABLE instead. I tried to run this query in the Query View: DEFINE VAR Sample_Table = DATATABLE( "First Name",STRING, "Last Name",STRING, "Time",DATETIME, { {"Reza","Rad",0}, {"Leila","Etaati",}, {"someone",,"2019-2-10"}, {"Unknown",blank(),"2019-2-10"} } ) EVALUATE EVALUATEANDLOG(Sample_Table) Then I got the error: "DAX Evaluate queries work only on databases which have at least one tables." Now after searching on google and asking copilot, I didn't get anything relevant to this. Then finally I decided to make a Calculated Table and as usual it worked and I could perform all the operations. Now I tried once again to debug the previous code. So I deleted that Caluclated Table and then ran the query, that I've provided above, in the Query View. To my surprise, the query ran and gave the output. I thought it maybe because of cache so I canged the values in DATATABLE and again the query gave output with changed values. To summarize this, I am providing the recording of the same. Please tell if this is some kind of bug or is there something wrong with the code. Link to Video
Solved
SidArt0731
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
4Comments
Active Directory users are unable to upload reports to Power BI Report Server (January 2024)
Bug Report - Active Directory users not listed in the dbo.Users table are unable to upload reports to Power BI Report Server (January 2024) We are running several on premises Power BI Report Server installations in different Active Directory domains. All the report servers are running the latest update - January 2024. We recently discovered that some of our report developers are unable to upload new or changed reports to some of our report servers. Steps to reproduce the issue The affected report developer (the user) logs in to the web interface for the report server at https://ServerName.mydomain/Reports using his or her Active Directory account (Kerberos authentication - single-sign-on since the report server web sites are part of the intranet). The user browses to a report folder on the report server. The user clicks Upload in the web interface and chooses a PBIX file from the local computer. If the target report already exists, the user is presented with a dialog asking if the report should be overwritten. The user selects Overwrite. At this point, the web interface seems to hang from the perspective of the user. No progress feedback is provided and the web interface is grayed out. After precisely 5 minutes, the web interface reports to the user that the upload failed with the following error message: An error has occurred. An internal error occurred on the report server. See the error log for more details. Information points For non-affected report developers, the above operations work without any delays and without any error messages. New or changed reports are uploaded within a few seconds to the various report servers. Affected report developers can upload reports to some report servers without any issues. On the affected report servers the operation fails as described above. All affected and non-affected report developers are members of the same Active Directory groups. All access management in Site Settings and specific report folders is administered using Active Directory groups that are common to the report developers. Access configuration is the same on both affected and non-affected report servers. Affected developers can even be system administrators, with full rights everywhere in the report server web interface through their AD group memberships, and still be affected by the issue. Further investigation results The only common cause for this issue that we have found is that: On the report servers where the issue exists, the personal Active Directory user accounts of the affected report developers are not yet listed in the table dbo.Users in the ReportServer database. As soon as the user account of an affected report developer is added to the dbo.Users table separately, for example by temporarily adding some access rights directly to the personal user account on a report folder, uploading reports starts working for that user everywhere on that report server. Later removing the temporary access rights again does not impact the outcome of the report upload operation. On the report servers, we have only found one error message related to the problem. It can be found in the log file RSPortal_<datetime>.log. <datetime_start>|INFO|138|Received request PUT /api/v2.0/catalogitems(<ItemGUID>)| RequestID = <RequestID> <datetime_start + 300 seconds>|ERROR|138|library|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.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- 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 Dapper.SqlMapper.<QueryRowAsync>d__34`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 Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection.<QueryFirstOrDefaultAsync>d__15`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 Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection.<QueryFirstOrDefaultAsync>d__14`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 Microsoft.BIServer.Configuration.Catalog.CatalogAccessFactory.<QueryFirstOrDefaultAsync>d__5`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 Microsoft.ReportingServices.CatalogAccess.CatalogDataAccessor.<GetUserID>d__9.MoveNext() --- End of inner exception stack trace --- at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification) at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.SetDataModelDataSourcesTrusted(IPrincipal userPrincipal, Guid itemId, IEnumerable`1 dataSources, Boolean isOverwrite) at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass82_0.<| RequestID = <RequestID> <datetime_start + 300 seconds>|INFO|138|library|Report server dump occured. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out, Message: , Unhandled Exception: False| RequestID = <RequestID> <datetime_start + 300 seconds>|INFO|138|library|Report server unique dump occured. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out, Message: , Unhandled Exception: False| RequestID = <RequestID> <datetime_start + 300 seconds>|INFO|138|library|Dump result: External dump process return code 0x20000001. External dump process returned no errors. .| RequestID = <RequestID> <datetime_start + 300 seconds>|ERROR|138|OData exception occurred: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out.| RequestID = <RequestID> <datetime_start + 300 seconds>|INFO|139|Sending response. Response code <UserDomain>\<UserName> 500, Elapsed time 0:05:05,7753504| RequestID = <RequestID> Monitoring of and traces on the SQL Server instances where the ReportServer databases reside reveal that: There are two SQL sessions involved in the report upload activity from the report server side: Session A - application name "Report Server" - responsible for uploading the report and modifying the related SQL tables. Session B - application name "RSPortal" - responsible for reporting status of the operation back to the report developer. Session B is blocked by session A until session B reaches its execution timeout of 5 minutes and is terminated by the report server, resulting in the error message in the RSPortal.log file above. The last few SQL statements in session A before the error occurs can be seen below: exec SetLastModified @Path=N'<ReportPath>',@ModifiedBySid=<SID_of_Report_Developer>,@ModifiedByName=N'<UserDomain>\<UserName>',@AuthType=1,@ModifiedDate='<ModifyDate>' exec UpdateCatalogContentSize @CatalogItemID='<ReportItemID>',@ContentSize=262381 exec UpdateDataModelParametersById @CatalogItemID='<ReportItemID>',@Parameters=N'[]' The last SQL statement in session B can be seen below. It is blocked by an active transaction in session A above. declare @p4 uniqueidentifier set @p4=NULL exec GetUserID @UserSid=<SID_of_Report_Developer>,@UserName=N'<UserDomain>\<UserName>',@AuthType=1,@UserID=@p4 output select @p4 The blocking in the database is centered around the dbo.Users table in the ReportServer database. An open transaction in Session A holds an exclusive lock on the table, causing session B to pause, waiting for the table to become available again. When monitoring the sessions interactively during the execution timeout period, no active work is being performed by session A after executing the last few statements above. No reads or writes are taking place and no CPU resources are consumed even though the session has an active transaction running. When the execution timeout for session B occurs, the operations in both sessions are rolled back and errors are reported in the report server log files and in the user interface to the report developer. Workaround Add the personal user accounts of the affected report developers to the dbo.Users table in the ReportServer database separately. Example: Grant access rights in Site Settings or on a report folder to the specified personal user account. Then remove the access rights. When the workaround is in place, session A above behaves differently and continues executing SQL statements during the report upload operation. No blocking between session B and session A occurs. Session A SQL statements with the workaround in place: exec SetLastModified @Path=N'<ReportPath>',@ModifiedBySid=<SID_of_Report_Developer>,@ModifiedByName=N'<UserDomain>\<UserName>',@AuthType=1,@ModifiedDate='<ModifyDate>' exec UpdateCatalogContentSize @CatalogItemID='<ReportItemID>',@ContentSize=262381 exec UpdateDataModelParametersById @CatalogItemID='<ReportItemID>',@Parameters=N'[]' -- Session stops here when the report developer is not in the dbo.Users table exec ObjectExists @Path=N'<ReportPath>',@AuthType=1 exec GetAllProperties @Path=N'<ReportPath>',@AuthType=1 ...
Solved
JonasDedicatum
2 years ago Place Report Server
1.5KViews
0likes
2Comments
Fonts with names > 32 characters get trimmed leading to invalid font selection online
I finally found the source of an aggravating bug (I hope it's a bug). Take a look at this! That's a default Microsoft font too! It's the same in the dropdown except because the tiny width of it, you can't read past 18-20 characters anyways, so it's harder to notice what's happening. For whatever reason, when you select one of these fonts and run the report in desktop, they render fine. But view it in a browser and none of those fonts that get cut off will work.
ishazel
2 years ago Place Report Server
555Views
0likes
1Comment
Report builder's Navigation Getting Disable
Hi, I have a rdl published in powerbi service. Navigation buttons getting diable in the below scenario, 1) Moving to last page 2) Back to first page Navigation buttons are disabled and view report button got enabled. If I want to move to other pages, I can only do so after clicking view report. How can I overcome this issue? Regards, Karthika
Anonymous
2 years ago Place Report Server
396Views
0likes
0Comments
Calculated Column not being executed
Hello! I have a table called Progression1 with a calculated column generated with the following code: Rate= CALCULATE(sum(Masterfile1[Awarded]),Masterfile1[STATUS]="GRD",Progression1[Term])/42.34) It works perfectly, and it creates a column with the values that I need. However, when I try to replicate in my second table called Progression2, like this: Rate= CALCULATE(sum(Masterfile2[Awarded]),Masterfile2[STATUS]="GRD",Progression2[Term])/42.34) Nothing happens. I don't get the usual loading screen and seems like the code is not being executed at all. If I click anything afterwards the calculated column goes back to the default Column = Anyone has any idea why does this happens? Is it something on my end? Thank you!
Pablinho
2 years ago Place DAX Commands and Tips
692Views
0likes
3Comments