Parameter table does not work in the service or app

[CBO2404]

In my dataset I create a field parameter table with some measures. I publish this dataset to the service. 

I have a report,with a live connection to the dataset, with a matrix visual that uses the parameter table measure as its value.

I also have a slicer in my report with the parameter table fields.

In Desktop, it works fine — when I select a different measure in the slicer, it switches correctly via the parameter in my matrix visual. However, when I publish the report, the visual in the Service returns an error when displaying the information. What could be wrong?

This is the parameter table:

Parameter Trend Report Calculations = {
("Internal revenue per client", NAMEOF('_Measures_Revenue'[Internal revenue per client]), 0),
("Internal revenue per deployed FTE", NAMEOF('_Measures_Revenue'[Internal revenue per deployed FTE]), 1),
("Number of cost centers (with revenue)", NAMEOF('_Measures_Revenue'[Number of cost centers (with revenue)]), 2),
("Number of employees (Payroll)", NAMEOF('_Measures_Payroll'[Number of employees (Payroll)]), 3),
("Total FTE", NAMEOF('_Measures_FTE'[Total FTE]), 4),
("Number of Clients PBL", NAMEOF('_Measures_ProductionBase'[Number of Clients PBL]), 5),
("Number of Clients PBL (Residential)", NAMEOF('_Measures_ProductionBase'[Number of Clients PBL (Residential)]), 6),
("Number of Clients PBL (VPT)", NAMEOF('_Measures_ProductionBase'[Number of Clients PBL (VPT)]), 7),
("Number of Clients PBL (MPT)", NAMEOF('_Measures_ProductionBase'[Number of Clients PBL (MPT)]), 8),
("Total Revenue", NAMEOF('_Measures_Revenue'[Total Revenue]), 9)
}

[CBO2404 · Accepted solution]

I solved it myself by deleting the parameter table and recreating it in the dataset. I then republished it and, in the report, removed the matrix and rebuilt it. Now it seems to be working again both in Desktop and in the Service. Still, it’s rather strange. Thanks for all the tips

[Syndicate_Admin]

Hello!

Could you provide a screenshot of the error you receive?

Best regards

[CBO2404]

[rohit1991]

Hi @CBO2404 

Could you please try below steps :

1. Keep the field parameter in the dataset (model), not the thin report.
   With a live connection, the report can use a parameter but can’t own it.

2. Permissions (most common):
   If the report is in a different workspace than the dataset or shared via an App, give viewers Build permission on the dataset (or in the App, turn on Allow users to connect to the underlying semantic models). Without that, the visual can error even though it works in Desktop.

3. Republish both pieces:
   Publish the dataset first, then the live-connected report. Make sure the report points to the same, latest dataset.

4. Sanity checks:

   • Every parameter item points to a measure (not a column).

   • No broken measure references after publish.

   • Viewer has permission to the workspace + dataset.

[CBO2404]

1. The parameter table is in the dataset. I have multiple parameter tables that work the same way, and they do not produce any errors.

2. Permissions are set correctly. Other parameter tables work fine.

3. I tried already and doesnt work
4. I tried it with fewer parameters (from the same measure table), but the same problem occurs.

It has worked in the past. Could there be something related to a version or setting on the server side?