Forum Discussion
Paginated Report - Help With Parameters
I got this figured out. I had pasted the query for the paginated report from the Power BI desktop query in the performance analyzer. That creates a completely different DAX query than if you add your model and drag and drop your columns/measures into the query designer from scratch. Once I did this, the parameters were fine. I did have to include an "ORDER BY" at the end of the query because it doesn't alphabetize them.
One of these links might help you. You need to add the parameter to the RDL, eithe a query parameter to filter data as it comes in our a report level parameter to filter data in the report. Then you need to bind a field from the PBIX dataset to that parameter. Some pictures and instructions in third link.
https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-parameters
https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual