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.
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.
I'm sorry but it seems I'm not getting you.
you can defenetly use drag and drop to build your queries over Power BI Datasets in Power BI report builder.
If I have this correct , if I drag and drop fields from different tables (not measures) they dont have the link between and run independantly of eachother ?
I've had a look around and found this, does it make sence that if I put any measure in it recognises the relationships ?
Solved: Relationship between tables in Power BI Report Bu... - Microsoft Fabric Community