Paginated Report Map Parameters on Power BI report not matching Filters Applied

[mecaroma]

I have a Paginated report created from a Power BI report both connected to the same Azure SQL dataset. Data includes clients, programs, invoices, start/end dates, sum of totals amounts due. I set start/end date parameters in paginated report as date/time data types and none for available/default values and also created a >= and <= statement in the query and added parameter names/values linked back to the start/end date parameters. When I try to add the paginated report visual to the Power BI report and map the parameters, it does not recognize the filters and apply them as current values to the paginated report data - see screenshot below. I have searched and cannot seem to find why this is happening. Anyone have any tips? Thank you for your help!

[mecaroma]

@v-yanjiang-msft thank you for tracking down that article for me. I will go look up more on how to accomplish one of those bullets in the work-around options. 

[v-yanjiang-msft · Accepted solution]

Hi @mecaroma ,

When you use a Power BI dataset as the data source for your paginated report and set up a date parameter in your query that then automatically generates the parameter table and parameter, using that parameter in a paginated report parameter will fail. The paginated report visually treats the parameter as a text field and fails to match the Power BI date field. You have three work-around options:

• From the same Power BI data source, create a new dataset with only the date values. Use this dataset as the available values for your parameter, setting the data type of the parameter as Date/Time.
• Manually change the DAX query text in the auto-generated dataset to remove the part that sets the parameter to be a text value.
• Change the Power BI dataset using Power Query to add a column that formats the date field as a text field.

Reference: Create and use the paginated report visual - Power BI | Microsoft Learn

Best regards,

Community Support Team_yanjiang

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