Forum Discussion
Power BI Desktop includes extra tables when refreshing from a linked Power BI semantic model
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.
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.