Forum Discussion
Sjmiller
2 years agoRegular Visitor
PowerBI Paginated Report wildly wrong
I have a published dataset on powerbi, I connect that data source to my paginated report, when I am in the query editor I drag over the fields I want to bring it. I also set my parameters. For a te...
amitchandak
Super User
2 years agoSjmiller , Based on what I got, once you create a dataset in the paginated report and you already used a measure of countdistinct , that set is a table and now you are doing sum or count on that column.
To get that add the ID to the paginated report dataset and create a count distinct calculation there
Sjmiller
2 years agoRegular Visitor
I am not creating report in PowerBi derive for paginated reports I am doing in the report builder desktop program