Migrating Pages from one PBIX file (Desktop) to another (Onpremises Remote Server)
Good Morning, I am building a new version of a dashboard (into Onpremises Remote Server Version: 2.150.1926.0 64-bit (January 2026) from a version previously created in Desktop 2.145.1105.0 64-bit (July 2025)). There are over 30 tables and over 15 pages in the existing dashboard. I am moving across the Tables (to the new PBIX file) and creating the relationships between them manually. I considered it better to make the effort to manually join the tables in Model View - rather than autodetect - so that I know exactly what Table is linked with which Table (and upon what fields). Or would autodetect have been preferable ? Now the main issue is copying the 15-ish pages (with the plethora of visuals contained within these !) to the new PBIX file, especially that several of them contain Overlays (with buttons allowing different views of the data to be presented). So such pages may have many Visuals contained which are hidden - dependant on which view button has been invoked. For example: Kindly advise if there is an efficient way to move across the pages. RegardsIssues Migrating Existing Dashboard to On-Premises Version (January 2026)
Good Afternoon, I am creating a new version of an existing Dashboard (currently in Version: 2.145.1105.0 64-bit, July 2025) to the On-premises Remote Server one (Version: 2.150.1926.0 64-bit, January 2026). I have a couple of issues already: 1) One of the Tables is a Dates Table - I have copied exactly the correct formula in, but I am getting a error "a circular dependency was detected". 2) Model View - its only showing one table which ironically is the error-giving Dates Table, while none of the other Tables (which are actually all fine) are not showing at all: Kindly advise. Regards
Assistance Required in Paginated Report/SSRS Report
Hi Team, I hope this email finds you well. I am reaching out for your assistance in resolving an issue I am encountering with a paginated report. The report is designed such that after selecting multiple parameters, clicking on the Reject column record redirects to a child report. However, an error is displayed: "The report parameter list exceeds the limit of 2040 characters, needs to reduce the selected values for Zone 1, 2, 3 WO# dropdown." I need assistance in ensuring that even after selecting "Select All" for the parameters, the report does not exceed the character limit and continues to function without errors. I have also attached the expression used to achieve the functionality for your reference: =IIF(LEN(Globals!ReportServerUrl +"?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " &Join(Parameters!parshiftinclude.Value,",") & "&moduleky= " & Fields!MODULE_DIM_KY.Value & " &pruntype= " &Join(Parameters!paruntype.Value,",") & "&Zone1Wo= " & Join(Parameters!Zone1Wo.Value,"&Zone1Wo="))<=2083, "javascript:void(window.open('"+ Globals!ReportServerUrl +"?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " &Join(Parameters!parshiftinclude.Value,",") & " &moduleky= " & Fields!MODULE_DIM_KY.Value & "&pruntype= " &Join(Parameters!paruntype.Value,",") & "&Zone1Wo= " &Join(Parameters!Zone1Wo.Value,"&Zone1Wo=") & "'))", "") ' --- Max URL limit accepted by IE browser is 2083 char Looking forward to your assistance! Thanks & Regards, Heena KousarPower bi paginated reports matrix total of filtered row group
Hi, I have created a matrix in the paginated report. I created a row group in the matrix where I am showing the sales (sum(sale_amount) for only those products who sold atleast 100 quantities or more in the current month. The filter on the group is count(items) >= 100. This works fine and gives the desired result. Now we wanted to add a total to this group to see the total sale amount. The problem with the total is that it shows the total sales of everything that is sold in the current month. I want the total to only total the sale of the group where the filter is count(items) >= 100. Can someone please give me a solution to this. Regards
