Forum Discussion
PBI_learn_NK
1 year agoFrequent Visitor
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...
ajohnso2
1 year agoSolution Supplier
Your tables should already be joined in your PBI model? Im unsure why you are trying to do it in paginated reports?
If you have a sample model to share it would be useful
PBI_learn_NK
1 year agoFrequent Visitor
Thank you for your response!
The tables aren't joined in the Power BI semantic model, as there are other considerations around cardinality and business logic that will affect how the relationships are defined. For now, I'm working with the dataset directly in the paginated report.
Unfortunately, I can’t share the model from my office machine due to data privacy policies, but I’m happy to clarify any specifics if needed.