Assistance Required for Resolving URL Character Limit Issue in Paginated Report
Hi Team, I hope this email finds you well. I am reaching out for 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. Please reduce the selected values for Zone 1, 2, 3 WO# dropdown." To provide more context, I have attached the expression currently being used to achieve the functionality: =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=") + "'))", "") The main concern is ensuring that even after selecting "Select All" for the parameters, the report does not exceed the character limit and continues to function without errors. If this issue cannot be resolved due to known limitations, I would appreciate any suggestions for alternative approaches. Specifically: Is there a way to handle this within the report itself, avoiding the need to jump to a child report? After publishing to Power BI Service, can any modifications be made to overcome this limitation? Are there any other workarounds to ensure that selecting "Select All" does not lead to an error? Looking forward to your valuable suggestions and assistance! Thank you. Best regards, Heena KousarCan we build a table in calculated filed like attached image?
Hi, I need to build the like below: Can we build the above table? How can we build the fileds at Left Side like Gross Sales, REBATE, RXs etc?means Left Side columns are measures, and should show under PRODUCT SET DESCRIPTION collumn. So, can we create column like this?
Power BI Monitoring Implementation Issues with Fetch Catalog and Fetch Graph Scripts
I am currently implementing Power BI monitoring as outlined by Rui Romano. My goal is to extract logs and store them on my local system using PowerShell scripts, specifically the 'Fetch Activity', 'Fetch Catalog', 'Fetch DatasetRefresh', and 'Fetch Graph' scripts provided in the GitHub Repository i.e. public repository. So far, I have successfully executed the 'Fetch Activity' and 'Fetch DatasetRefresh' scripts and have connected the extracted data from these activities to the Power BI template file available in the GitHub repository at the end of the page(Ref Image Steps to Execute PBIMonitoring ). However, I am encountering issues with the 'Fetch Catalog' and 'Fetch Graph' scripts. For the 'Fetch Catalog' script, I am receiving a "missing braces" error(Ref Image Error_On_FetchCatalog), and even after resolving that issue, I am unable to connect the generated data from the catalog to the Power BI template due to missing workspace-related information. Regarding the 'Fetch Graph' script, I am facing a "403 Forbidden" error (Ref Image Error_on_FetchGraphps1) , which appears to be related to the permissions assigned to the service principal. I have already added the following permissions to the service principal(Ref Image ServicePrincipalPermissions) Could you please provide assistance with the 'Fetch Catalog' and 'Fetch Graph' scripts, as well as guidance on the necessary permissions that need to be added to the service principal? Any help or suggestions would be greatly appreciated.
Sell Through DAX measure
Hello everyone! I need some help with DAX. Basically, I have to calculate SELL_THROUGH of the stores (CD_LOJA_SAP) and skus (CD_EAN) where [SELLOUT] AND [POSICAO_ESTOQUE] are not blank ou zero. Here is an example, using CD_LOJA_SAP: 1. How it is at the moment: 2. How I want it to be: As you can see, the measure works correctly for the rows in the table. However, the issue lies with the "Total" row. I need it to exclude stores 1 and 2. My model: DAX measures: SELL_THROUGH = VAR MaxData = [MAX_DT_ESTOQUE] VAR Estoque = [POSICAO_ESTOQUE] VAR Sellout = [SELLOUT] VAR Estoque_Sellout = [POSICAO_ESTOQUE_SELLOUT] VAR ST = SWITCH( TRUE(), ISBLANK(Sellout) || ISBLANK(Estoque), BLANK(), DIVIDE(Sellout, Estoque_Sellout) > 1, 1, DIVIDE(Sellout, Estoque_Sellout) ) RETURN ST MAX_DT_ESTOQUE = VAR MaxData = CALCULATE(MAX(fEstoque[DT_ESTOQUE]), ALL(fEstoque),fEstoque[CHAVE_COLECAO_COMERCIAL] = SELECTEDVALUE('Coleções'[DS_COLECAO])) RETURN MaxData POSICAO_ESTOQUE = VAR MaxData = [MAX_DT_ESTOQUE] VAR PosicaoEstoque = CALCULATE( SUM(fEstoque[QT_ESTOQUE]), fEstoque[DT_ESTOQUE] = MaxData ) RETURN PosicaoEstoque SELLOUT = VAR MaxData = [MAX_DT_ESTOQUE] RETURN CALCULATE( SUM(fSales[VOLUME]), fSales[DT_PEDIDO] <= MaxData ) POSICAO_ESTOQUE_SELLOUT = [SELLOUT] + [POSICAO_ESTOQUE] Could anyone please help me? Thank you so much!
