Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jostnachs
Helper III
Helper III

embedded paginated report with parameters doesnt work

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

jostnachs_0-1725646286995.png

Kindly help

5 REPLIES 5
v-jtian-msft
Community Support
Community Support

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

jostnachs
Helper III
Helper III

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

 

1.Below is the report query

jostnachs_0-1725905818130.png

2. parameters and the definitions

jostnachs_1-1725905898744.pngjostnachs_2-1725905923435.pngjostnachs_3-1725905946287.png

3. Parameter table

jostnachs_4-1725905999041.png

4. power bi 

jostnachs_5-1725906034626.png

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.

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.

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.

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...
like this:

vjtianmsft_0-1725932894251.png

vjtianmsft_1-1725932902690.png

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

vjtianmsft_2-1725933074408.png

create a new DAX query

vjtianmsft_3-1725933091502.png

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)

vjtianmsft_4-1725933181855.pngvjtianmsft_5-1725933188888.png

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

vjtianmsft_6-1725933213579.png

 

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

vjtianmsft_7-1725933467496.png

 



 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.

v-jtian-msft
Community Support
Community Support

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.

vjtianmsft_0-1725857699851.png

2. Use subqueries to filter the paged report data set

vjtianmsft_1-1725857735174.png


I started by creating a paginated report

Parameter Configuration:

vjtianmsft_2-1725857906636.pngvjtianmsft_3-1725857914036.png

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

vjtianmsft_4-1725857988463.png

Text type parameter animalName

vjtianmsft_5-1725858013575.png
It's best to create a dataset specifically for the text type parameter to get the data to avoid problems

vjtianmsft_6-1725858048107.pngvjtianmsft_7-1725858065887.png

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

vjtianmsft_8-1725858087700.png

Please ensure that the query parameters are bound correctly

vjtianmsft_9-1725858107902.pngvjtianmsft_10-1725858117575.png

 

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

vjtianmsft_11-1725858153584.png

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).

vjtianmsft_12-1725858217662.png

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)

vjtianmsft_13-1725858244913.png

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)

vjtianmsft_14-1725858269746.png

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

vjtianmsft_15-1725858294789.png

Success changes outcomes

vjtianmsft_16-1725858334518.png


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

vjtianmsft_17-1725858358725.png

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.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.