Forum Discussion
Power BI Desktop includes extra tables when refreshing from a linked Power BI semantic model
Hi RF_CW,
Thank you for your follow-up and for confirming that Report B is using a local model with selected tables.
From your reply, if new tables from the source semantic model are still appearing in your report without being added manually, this isn’t the expected behavior for a report connected to a local model. Normally, Power BI Desktop should not include new tables from the source model during refresh when only certain tables are selected.
To address this, please check the following:
Ensure that table additions aren’t caused by a metadata or schema sync when the source model (Model A) is updated or republished, as this can sometimes push schema changes.
Manually remove the unwanted tables in Report B’s model view, then go to File > Options and Settings > Data Source Settings, clear credentials, and reconnect using "Add a local model" with only the needed tables selected.
Turn off auto-date/time by going to:
File > Options > Data Load > Time Intelligence
Uncheck Auto Date/Time for new files to prevent automatic model changes.
If your organization uses deployment pipelines, XMLA endpoints, or scripted deployments, make sure no schema merge or sync operations are happening unintentionally during updates.
Thank you.
Thank you that's helpful.
My other question is - say I were to add a local model and follow the steps above; In the event that a table (LL) from Model A and i'm using in Report B is updated, then will the table LL in Report B be updated as well?
Hi RF_CW,
Thank you for your follow-up.
If you have connected Report B to Model A using a local model with DirectQuery, updates to an existing table such as Table LL in Model A will automatically be reflected in Report B. This includes data changes (new or modified rows) and column updates -- additions, deletions, or renames, so long as these do not disrupt current visuals or measures.
Because Table LL is queried directly from the source semantic model, Power BI ensures that the latest data and schema from Model A are displayed in Report B each time the report is refreshed.
However, that only the tables selected during the initial local model connection are included. New tables added to the source model afterward will not appear automatically in Report B, allowing you to keep your report schema organized and controlled.
Thank you for engaging with the Microsoft Fabric Community.
Hi RF_CW,
I wanted to check in your situation regarding the issue. Have you resolved it? Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi RF_CW,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.