Forum Discussion
Paginated Report Build using PowerBI Dataset
- 6 years ago
I did open Ticket with Microsoft and did get an answer from them.
The PowerBI Dataset Relationships are not supported when accessed from
Paginated Report Builder. There are two suggested ways to work around these
are to either rely completly on Measures from a PowerBI DataSet, or do setup
a Derived table by creating new Table using a DAX table funcion like FILTER.
And then relying on this single table for the Pag.Report. In my case, I needed both
of these ideas. I created a Drived table using FILTER to limit my main Fact table as needed.Then I can to create the various Measures needed in this FILTERED table to be used by the report.
It works, but looking forward to the future when this can be done much easier.
Any Update on this as its been about a year since the last comment here?