Forum Discussion
straubja
3 years agoFrequent Visitor
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...
- 3 years ago
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.
straubja
3 years agoFrequent Visitor
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.