Power BI RS January 2026 – Reports Using RLS Enter Infinite Reload Loop
We upgraded to the January 2026 latest release of Power BI Report Server, which is reported to include a fix for this issue: Version: 1.25.9558.32914 (build 15.0.1120.122), Released: March 5, 2026 Fixed issue where Power BI reports with RLS get stuck spinning. However, this keeps happening for any user that is not set-up with a Role in the RLS report. This is very confusing; previous versions were displaying a relevant error message that helped identify the issue (missing access rights). But now the report keeps reloading over and over! Please advise Regards
Remove blank when Parameter is selected
Hey guys, I need your wisdom with a matrix visualization where I have used a parameter to control the rows, allowing users to select their desired view. My goal is to hide rows that contain "Blank Approver" values when Approver Parameter is selected. Here’s the issue: The "Blank Approver" rows represent rejected items, which should not be displayed if the user selects an "Approved" type. The challenge is that the "Blank Approver" rows should not be shown regardless of the selected type (Approved or Rejected) when the parameter is applied. I have attached an image to illustrate how the matrix should look when both the parameter and type are selected (as an ideal scenario). Is there a way to achieve this behavior where the "Blank Approver" rows are completely hidden when only the parameter is selected? Parameter selected Parameter and Type is selected
Any way to display warning if data is stale from a data source error?
I'm using Power BI Report Server in import mode for a few reports/dashboards and have them displayed on large monitors. These dashboards are used to display real-time data (within the last 5 minutes). I have a script that clicks the refresh button on the dashboard every minute to catch the background refresh and ensure that the visuals are constantly updated on the display. I have a "Last Refresh" visual at the top of the dashboard which shows the last successful refresh. Is there any way to use HTML, pbiviz plugin, or some other method to compare last successful refresh time to the current system time when the refresh fails? I need a way for people to know that the data they're seeing is stale data because of a failure in refreshing from one of the data sources. As I understand it, the method would need to somehow have access to local system time as UTCNOW will have the last successful refresh time instead of the actual current system time.Determine if the value displayed is in cents or dollars
hi everyone, is there a trick or tip on how to determine if a value displayed in a graph is in cents or dollars? basically the formula is like this: Formula = VAR work = CALCULATE([Work]) VAR unit = CALCULATE([Unit],'Table1'[Column1]<>"S") RETURN IF(DIVIDE(work,unit)<1,DIVIDE(work,unit)*100,DIVIDE(work,unit))
How to filter table with value related to the selectedvalue
I have the two tables below in my power bi file. I have a slicer from Table2 that uses column [Month] as the selected value. If a month is selected, I want to calculate and filter Table1 where Table1 = the associated selected [Date Rank] from Table2 + 1. For example, if 24-Jun is selected from Table2, I want to filter Table1 where [Month] = 24-May. Table1 ID Status Date Rank Previous Status Month Type Group A Normal 3 No previous 24-Mar Task <0 B Normal 3 No previous 24-Mar Task 1 to 5 C Not Normal 3 No previous 24-Mar Task 1 to 5 D Not Normal 3 No Previous 24-Mar Not Task 11 to 15 A Not Normal 2 Normal 24-May Task 6 to 10 B Normal 2 Normal 24-May Not Task 6 to 10 C Normal 2 Not Normal 24-May Not Task 6 to 10 D Not Normal 2 Not Normal 24-May Task 6 to 10 A Not Normal 1 Not Normal 24-Jun Task 1 to 5 B Not Normal 1 Normal 24-Jun Task <0 D Normal 1 Normal 24-Jun Task <0 E Normal 1 24-Jun Task 1 to 5 Table2 Date Rank Month 3 24-Mar 2 24-May 1 24-Jun
Measure Does Not work Properly.
Full Name Contract Hours Worked Hours Pay date ABC 76 7.6 15/01/2024 ABC 76 7.6 15/01/2024 ABC 76 14 15/01/2024 JOHN 42 6 28/01/2024 JOHN 42 25 28/01/2024 JOHN 42 3 28/01/2024 Hi Everyone, Above is the sample data of the timesheet. I am getting correct results when i have a single pay date selected but when i add the same measure in matrix and add pay date in the column, i am not getting correct results I am not sure why. 1 st measure to calculate Hours Worked Worked Hours= sum('Table A'[Worked Hours]) 2nd measure to calculate contract hours as Contract hours is done for fortnight Contract Hours = SUMX( SUMMARIZE( 'Table A', 'Table A'[Full Name], "CONTRACT", max('Table A'[Contract Hours]) ), [CONTRACT] ) 3 rd to calculate difference Difference= [Worked Hours]-[Contract Hours] I am checking the variance of the hours so in the matrix i am doing Difference is less than 0 in the filter. Please can someone help me with this Thanks verymuch !!
