Forum Discussion
Issue with joining tables - semantic model as data source
Hi everyone, I’m in the process of migrating an SSRS (RDL) paginated report to Power BI Paginated Reports( PBI Report Builder ). I’ve set up a semantic model (created in PBI Desktop and publish...
Have you tried to join the tables using Power Query instead? When it comes to join operations, yes, you can do it using DAX, but the question you need to really ask before doing so is, "Should I?"
Thank you for your suggestion!
In this case, I’m not using Power Query for the joins because the data model is already designed for direct querying in Power BI, and the focus is on ensuring the paginated report uses the semantic model efficiently. The joins need to reflect specific cardinalities and filter behavior, which is managed more flexibly within DAX at runtime in this scenario.