How to get the data from PBI table to a Paginated report

[sajithQBT]

Hi friends,

I have a PBI dashboard with filters as shown below and also a Paginated report whose values are not changing when the filter value change. I tried writing expressions in the report editor for those column outputs but looks like my exp was not correct as they are throwing error. Could someone please help me? Thanks.

[sajithQBT]

Thanks for your quick response.

It worked and a great relief 😊 

It is just a begining of a big report. I will accept the solution now and create a new one if get stuck somewhere on the project.

Kind regards,

Sajith

[Anonymous]

Hi, @sajithQBT 

To interact with the slicer, you first need to set the parameters correctly in Report Builder and bind the dataset.
Here is a small test I did:
First I created a table in the report builder using the following dataset:

I set a parameter:

This parameter gets its value from another parameter, dataset. Below I will use this parameter to filter dataset1:

Check in the report builder that this parameter works properly:

You can find that this parameter works properly. Next, we publish the paginated report to Power BI Service

We open Power BI desktop, connect to the data source, and use the Paginated Report visual:

Next, you need to match the fields of the slicer to the fields of the paginated report settings. In my paginated report, the field used by the parameter is BusinessEntityID, so we drag this field onto the paginated report visual.

Next, we can interact with the paginated report through slicers:

Because the calculation logic of the table visual object is different from that of the paginated report.
The table visual object relies on the current row context, while the paginated report directly filters the data set based on the currently selected field. As the result of the test in the report builder.

Slicers only filter the data in our paginated report and do not dynamically calculate the values ​​corresponding to the row context. You need to set the content and data you need to display in the Report Builder.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sajithQBT]

Thanks Jianpeng for the response.

I did the below on my report builder but it is throwing error. Looks like I missed an important step in the process.

1) Added the dataset and wants to filter as per the customer group value.

2) Updated the Parameter properties

3) Updated the filter tab for the dataset

4) Error when executed

I am taking the dataset from an excel file.

[Anonymous · Accepted solution]

Hi, @sajithQBT 

Thank you for your reply. The current problem occurs because you use sheet1 as the source of your parameter. Then try to filter the sheet1 dataset through this parameter. This causes a loop, so the current error occurs.
You need to add another dataset and use that dataset to establish the parameter, as shown below:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.