Forum Discussion
Paginated Report Build using PowerBI Dataset
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.
I agree Anonymous , I would really like to see better integration from Microsoft also. For other Paginated reports I've had to make I have had to forsake any PowerBI integration and I'm back to just using Paginated reports via direct SQL queries just like it was a SQL Report server report. With all the progress that PowerBI provides, to have to resort to the very old style reports for Paginated reports seems very strange.
Indeed dclmorr . And I would use SQL queries on a SQL database if my data were on a SQL database...but my data is in MongoDB...I use the ODBC BI Connector to pull the data to PowerBI desktop, and PowerBI Report Builder does not suport ODBC (and anyway, relationships would be inexistant).
What I am really wonderring is why wasn't this almost the first thought when Microsoft integrated PowerBI Datasets support in PowerBI Report Builder? That is a huuuuge pain in the ... not having the relationships.
I've just signed up for the Microsoft Business App virtual conf in May. Maybe that will provide an opportunity to ask that question. I'm pretty sure there will not be a session on Paginated-Reports, I'm guessing Microsoft if not trying to put it in the spot light given its current state.