Forum Discussion
embedded paginated report with parameters doesnt work
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.