Forum Discussion
Power BI Desktop includes extra tables when refreshing from a linked Power BI semantic model
When I add new tables to a semantic model in PBI Workspace, Power BI Desktop then includes the new tables when I refresh a report.
So for example, I add Table XX to a PBI Semantic Model A created from a Power BI Report.
When I refresh/update PBI Report B that is linked to PBI Semantic Model A, the Table XX gets automatically added to the report even though I don't want it to be added.
How do I stop that?
12 Replies
Thank you! didn't know this existed
Sandip_PalitSuper User
You'll need to create your report's connection in a specific way that enables a local model.
- Start with a new Power BI Desktop file. Go to Get data and select Power BI semantic models.
- Find and select the source semantic model you want to connect to (e.g., Semantic Model A).
- In the connection dialog box, you'll see a Connect button at the bottom right. Do not click it yet. Instead, look for the text link below it that says Make changes to this model. Click this link.
- A new window will appear, warning you that a local model will be created. Click Add a local model.
- You will now see a navigator window showing all the tables and views in the source semantic model. Check the boxes only for the tables you want to include in your report. Uncheck any tables you want to exclude.
- Click Submit.
Your new Power BI report will now have a DirectQuery connection to only the tables you selected. When new tables are added to the source semantic model later, they will not automatically appear in your report.
The easiest way to apply this fix to your current report is to:
- Create a new PBIX file using the "Add a local model" method described above.
- Open your old report in a separate Power BI Desktop window.
- Copy and paste the visuals from your old report file to the new one. This is usually much faster than rebuilding them from scratch.
If this explanation and solution resolve your issue, please like and accept the solution.
- danextian
You're telling OP how to connect to a semantic model via direct query which he has already done.
This statement is also factually incorrect
Your new Power BI report will now have a DirectQuery connection to only the tables you selected. When new tables are added to the source semantic model later, they will not automatically appear in your report.Doing the how to connect to the semantic model steps you provided will not prevent tables added later from being added to the local model.
Test AI-generated responses before posting. Use AI reponsibly.
I forgot to add that the Power BI report B does have a local model and this occurs as well even when we make the selections clear.
v-sgandrathiCommunity Support
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?