Forum Discussion
Solved
Eliminating duplicate parameter entries in PBI Report Builder
Hello, I have a paginated report which has one parameter (order number). However, when I run the report it shows duplicate values for the order number in the dropdown (over 3000) but there are o...
Just to close this loop, a coworker was able to determine the root cause of the problem. I had copy-pasted the query from PBI Desktop (bypassing the wizard) and did not realize that I had to assign the report parameter manually. Below is the snippet with the missing code highlighted.
Hopefully this is helpful to others.
d_gosbell
Super User
Super UserThe parameter values are populated from a query. If you are seeing duplicates it is due to an issue with the data or with your query. If the parameter dataset was auto-generated you can access it by right-clicking on the datasets folder in Report Builder and then choosing the "Show Hidden Datasets" option. You would then need to alter the query to do some sort of "group by" or distinct operation to eliminate the duplicates