Forum Discussion
Report Builder - Alternative
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.
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.
I agree DAX is already written for you in the Performance Analyser in PowerBi Desktop.
I think what I am missing is the ability to drag and drop fields in the 'query builder' in the Report Builder due to the relationships not been recognised.
