Forum Discussion
Report Builder - Alternative
Hi All,
I've been using Report Builder and woundered if there is an alternative solution to create printable pdf reports ?
I appreciate the Report Builder works as its intended but find key functions missing to make Report Building a simpler process.
Specifically not been able to utilise the relationship model in the puiblished PowerBi report when connecting to a powerbi data source.
Many thanks
Chris
It's defenetly makes sense. Report builder is live connected to power bi dataset and uses the relationships and all the model.
you're just sending a Dax query to the model and it happens exactly the same as creating a report live connected to a dataset in power bi desktop.
8 Replies
R1k91 is completely correct. The relationships work exactly the same in report builder. The only minor difference is that Desktop will do some extra things like injecting a count measure into a query if you don't add one yourself to prevent doing a full cross join of columns from different tables. Report Builder just runs whatever you ask it to run. If you are copying queries from Performance Analzyer they should work identically.
you can use Visual Studio to create RDLs but Power BI Report Builder is the best choice since it's always aligned with the service.
"
Specifically not been able to utilise the relationship model in the puiblished PowerBi report when connecting to a powerbi data source.
"
do you mean you miss the ability to see the model because is useful to uderstand it and build properly the report?From what I understand the relationship model does'nt come across from the PowerBi DataSource.
The DAX from PowerBI Desktop Performance Analyser utilises the relationships but using fields from multiple tables in the Report Builder does'nt.
When you build a dataset a in Power BI Report Builder based on a Power BI Dataset datasource you're performing a DAX query over that model. it means you're definetely using the Model, the Relationships and Measures already built in that model.
it's good because you won't have to reinvent the wheel.
