Forum Discussion
Issue with Data source setting
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 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,
Nemanja
Hi 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.