Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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
@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
Thx 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,
Lydia
These 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-... eq 'Help Desk Yöneticisi'
Both of them r MsSql server and yes, parent has many to many relation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.