Forum Discussion
Issue with Data source setting
Hi All,
Does anyone have any idea about the issue below? I tried changing the source data, which is a DirectQuery connection to another Semantic Model, but encountered this issue.
Hi NorahTran97 ,
Thanks for reaching out to Microsoft Fabric Community.
The error “A child can’t be both removed and included” generally occurs when the metadata structure between the connected semantic model and the report becomes inconsistent - for example, when tables, fields, or relationships are modified or removed in the model after it was connected in Power BI Desktop.
As you mentioned that you’re unable to edit or add new tables from the same semantic model, please try the following steps:
-
Open Power BI Desktop, go to File > Options and settings > Data source settings, and select Clear Permissions for the semantic model connection.
-
Close and reopen the file, then reconnect to the semantic model from Get Data > Power BI Datasets.
-
If the issue persists, try connecting to a copy of the same dataset published in a separate workspace to rule out any corruption or broken reference in the metadata.
Hope this helps. Please reach out for further assistance.
Thank you.
-
6 Replies
Hi NorahTran97,
I found the solution for the same issue in the below community thread.
https://community.fabric.microsoft.com/t5/Developer/A-child-can-t-be-both-removed-and-included-lakehouse/m-p/4838896?utm_source=chatgpt.comThanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.Hi NorahTran97 ,
Just to confirm, you have a report targeting Semantic model which is published to Power BI Service.
Now, you tried to retarget it to another semantic model which is also on Power BI Service?
If that is the case, i recommend that you install ALM Toolkit. Is is free, amazing tool used to easily compare metadata of published semantic models.
It will find differences between these two semantic model.
Based on description, in new semantic model you are missing fields/tables which are used in old semantic model or are created on a report level.
Cheers,
NemanjaHi nandic
I’m trying to edit the current data source to add additional tables from the same semantic model, but I’m unable to make any changes or perform any actions related to the existing semantic model.
Hi NorahTran97 ,
Thanks for reaching out to Microsoft Fabric Community.
The error “A child can’t be both removed and included” generally occurs when the metadata structure between the connected semantic model and the report becomes inconsistent - for example, when tables, fields, or relationships are modified or removed in the model after it was connected in Power BI Desktop.
As you mentioned that you’re unable to edit or add new tables from the same semantic model, please try the following steps:
-
Open Power BI Desktop, go to File > Options and settings > Data source settings, and select Clear Permissions for the semantic model connection.
-
Close and reopen the file, then reconnect to the semantic model from Get Data > Power BI Datasets.
-
If the issue persists, try connecting to a copy of the same dataset published in a separate workspace to rule out any corruption or broken reference in the metadata.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi NorahTran97 ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
-
Hi NorahTran97 ,
Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.Thank you.
