I have toying arround with Power BI Report Builder and I didn't find that many tutorials about it yet. I tried to make a Parameter (which is essentially a filter at the top of the report page) on top of my matrix to select a supplier and business parameter like that. The thing I'm seeing is it list in the dropdown all the values of my table one after the other regardless if they are the same value or not. I find it a bit anoying because I don't want to see my supplier like 20 times in the dropdown if I have 20 lines in my table for this supplier. I was wondering if there was a way to do a GROUP BY on these Parameter so each distinct value only show once?
@tejaswidmello I'm aware that I'm talking about Power BI Report Builder on the Power BI Desktop forum (since there is no Power BI Report Builder forum yet) and I'm also aware that it's still in beta version but I'm wondering if anyone had a solution to my problem!
For now, we stopped trying to develop paginated report since it only works for PowerBI Premium and we have a regular PowerBI Desktop/PowerBI Service subscription. We don't have enough employees (around 200) to get PowerBI Premium.
PowerBI Report Builder could be useful instead of using SSRS though.