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
I found my problem. I used the COPY QUERY from the Desktop table I was replicating to get the DAX for the Paginated Report in the Report Builder. This gave it a very different syntax than dragging and dropping the columns and filters in one by one. Once I did it all manually it worked fine. But now my problem is that my parameter list is not sorted alphabetically. When I run the report, my paramter drop-down appears, but the locations are sorted in some random order which make no sense. I tried adding an "ORDER BY" to the query but I got a "Cannot Connect to Model" error, which is odd because it runs fine otherwise. Still digging and scratching my head.