topic embedded paginated report with parameters doesnt work in Report Server

embedded paginated report with parameters doesnt work

jostnachs — Fri, 06 Sep 2024 20:01:12 GMT

Hi Everyone... I have the same issue that my paginated report not updating . the paginated report works fine by itself. I have two parameters one is date where the default and available values are set to none and other is text where default values and available values are from query. I have no idea how i can change these settings to make it work in my power bi desktop. the below selection has 4 values which my power bi report shows but my paginated report shows 0 values

Kindly help

Re: embedded paginated report with parameters doesnt work

Anonymous — Mon, 09 Sep 2024 05:20:27 GMT

Hi,@jostnachs . I am glad to help you.

You can reconfigure your reports based on my testing process, hope this helps!
This is my test procedure

Conclusion: After my test, when you use subquery to get the data source data or use parameter filters, it can be embedded into Power BI desktop as a paging report visual properly.

1. Use filters to filter the paging report dataset.

2. Use subqueries to filter the paged report data set

I started by creating a paginated report

Parameter Configuration:

The Availables Values and Default Values for both time filter parameters (Start & End) are None.

Text type parameter animalName

It's best to create a dataset specifically for the text type parameter to get the data to avoid problems

Subquery to get data from the dataset (you can also filter the data with Filters, both work)

Please ensure that the query parameters are bound correctly

Uploading paginated reports to the power BI service works fine (be careful to configure the gateway)

Then use power bi desktop to create the report, here I am using the same data source

Loading the paginated report visual

Note that you need to pay attention to the order when adding the paginated report visual
1. Click on visual first, then add the filter fields (all the fields you want to add to the slicer).

Select the paginated report you need to add (it has been successfully uploaded to the power bi service and the gateway has been configured and is working properly)

You need to close the Use default button and select the field you just added in (be careful to keep the data type of the field consistent)

After adding the slicer, select the options, and then click Apply changes on the paginated report.

Success changes outcomes

I also tested that when you use the date slicer (when you select the between type, the value filtered on the later date cannot be added as a filter to the paginated report visual. You can see in the red area that the visual shows data after 4/23/2024).
Therefore it is not recommended to use the between type

I hope that the official documentation will help you.
URL:
Create and use the paginated report visual - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: embedded paginated report with parameters doesnt work

jostnachs — Mon, 09 Sep 2024 18:21:26 GMT

Hi, Thanks a lot for the help. I did exactly same.

1.Below is the report query

2. parameters and the definitions

3. Parameter table

4. power bi

the date parameters are set to none in paginated report. But if u see my pbix screenshot, the selection brings empty rows in the paginated report but actually there are values.

Re: embedded paginated report with parameters doesnt work

Anonymous — Tue, 10 Sep 2024 01:59:53 GMT

Hi,@jostnachs . Thank you for your reply.
I noticed that your data source is not the usual sqlserver but an off-the-shelf semantic model (using dax statements to query the model data)
You didn't provide a screenshot of the paginated report running, so I can't rule out if there is a problem with the DAX statement you are writing to get the data. Could you please check if your DAX statement is fetching the target data properly (even if the date parameter is set to null)
If possible, could you share the final results of the paginated report in Power BI Report Builder (including the final screenshot with different combinations of your parameter choices) to check if the paginated report itself can display the data properly under each combination of parameters. (You will need to mask the screenshots of the paginated report to protect your private data.)
Since the data source you are using is power BI service semantic model, if the report is in import connection mode, you can use XMLA (you need to have PPU or premium license, and enable XMLA read/write privileges in Admin portal) to realize remote connection to the report in SSMS. Connect to the semantic model of the report in workspace (since the Power BI report model is actually an AS model, you can process and view it as an AS model)
URL:
Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn
like this:

XMLA remote connection workspcae using SSMS (SQL Server Management Studio):

create a new DAX query

Just like using DAX view on Desktop, you can now check what data is actually stored in a semanticmodel published to a service by using the xmla implementation.
To narrow down the scope of the check
Examine the paginated report query semantic model statement in desktop (run the DAX code you showed in the paginated report)

Check the data in the semantic model published to the service in ssms
(Run the DAX code you showed in the paginated report) Check that the dax statements written in the paginated report are valid

In addition, please test, when your Date parameter setting is not set to None, Desktop in the paginated reports run whether the data can be displayed normally, please provide the corresponding screenshots, which will help you quickly find out where the problem lies.

2. If you can be sure that it is not the DAX code problem when you make your own report. Then you please check the desktop operation: check whether the parameters of the paginated report is set up correctly bound, whether the data type is matched.

3. Change the version of Power BI Desktop.
Try to use other version of Power BI Desktop to see if it can solve your problem. (Please save the important data beforehand to avoid loss)

Links to download historical versions of Desktop:
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

4.Please check if you have triggered a limit during the design process and make sure that the parameters correspond to each other correctly.
URL:
Create and use the paginated report visual - Power BI | Microsoft Learn

Re: embedded paginated report with parameters doesnt work

Anonymous — Thu, 19 Sep 2024 01:56:01 GMT

Hi,@jostnachs .I am glad to help you.

Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.

Re: embedded paginated report with parameters doesnt work

Anonymous — Wed, 25 Sep 2024 04:12:30 GMT

Hi,@jostnachs .I am glad to help you.

For your current issue, I think it could be due to slight differences in the values of the fields in the Power BI report and the values of the same named fields in the paged report. For example, there is a formatting difference between the value in the normal report filter field and the value in the paged report. This results in an empty paging report.
I am very concerned about the issue you are experiencing, can you please let me know if you have resolved this ISSUE by now and if you can provide more detailed steps on how to do it, it will help to quickly find out what the problem is.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian