Forum Discussion
Maybe, Is there a bug about dynamic filtering with the new feature - composite model preview?
I have a parent report and a child report as dynamic filtered report.
(as There is web url that opens the child report in a new browser.)
But when i trying to publish, it gives warning as the report is composite model preview. You dont publish.
So i am going options menu and control the composite model preview option and it is unchecked.
But still i couldnt publish it.
what should i do?
note : Both of them isnt composite but the datasets r different.
selsor,
Do you create many to many relationship as described in this article https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships? If so, this is a new feature which is included in composite model. There is a similar thread for your reference.
You would need to use traditional method that create bridge table, then establish many:1 relationship between table 1 and bridge table, and establish many:1 relationship between table 2 and bridge table.
Regards,
Lydia
4 Replies
selsor,
Do you create many to many relationship as described in this article https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships? If so, this is a new feature which is included in composite model. There is a similar thread for your reference.
You would need to use traditional method that create bridge table, then establish many:1 relationship between table 1 and bridge table, and establish many:1 relationship between table 2 and bridge table.
Regards,
LydiaThx a lot.
I see then.
And i also read this.
I will try 1 to many relations.
selsor,
Could you please describe more details about "There is web url that opens the child report in a new browser"? How do you set the web url in parent report? Do you use many to many relationship in parent report? Also what are the data sources in the two reports?
Regards,
LydiaThese web url icons r going to another report.
Example of link :
https://app.powerbi.com/groups/007c0bf8-4f06-4520-92e1-cf9b6197c04d/reports/8bf136a4-4d7f-4d3b-ae81-a9b61b90c/ReportSection?filter=IssueText/Handler eq 'Help Desk Yöneticisi'
Both of them r MsSql server and yes, parent has many to many relation.
