Forum Discussion
Using multiple models within a report
In reporting tools like Excel or SSRS, creator can connect to multiple models (via Excel Pivot Tables or SSRS Datasets/Query Designer) and refine/filter the data they need from the model. This is rat...
Hi ScottKC ,
For your question, you can ask someone with modeling experience to create a Power BI report first. After joining the required multiple tables, then create relationships between tables. Then place the visuals you need to use. Use DAX to create measures to populate visuals. Finally, set up RLS and publish to a collaborative workspace in Power BI Service. Add your users to the workspace as viewer roles. The data will be filtered based on the user.