Forum Discussion
Eliminating duplicate parameter entries in PBI Report Builder
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.
I added a second query to get a distinct set of values from the 'order number' field, and when I use that for the available values it gives me a clean list, but the relationship between the two datasets is not functional and I don't know how to change that. I can replicate a non-paginated version of what I want in Desktop, but not in Report Builder. Any suggestions?
- d_gosbell
Super User
straubja wrote:
but the relationship between the two datasets is not functional and I don't know how to change that.
There is no such thing as relationships between different datasets in a paginated report. And it would not be needed in this case anyway. The user selects a value or values from a parameter and those are passed to the main dataset. As far as the main dataset is concerned it does not care if those values originated from a second dataset or if they were manually typed in.
You could possibly try using some sort of profiling tool for your data source to see how the parameter values are being passed through,
