Import tables include columns for other tables

[AlexG14]

Very random question.

When I import tables from SQL, BI is including columns for other tables not requested.  The system we use (JobBoss) was upgraded on Friday and there are changed to the tables in my data model.  These changes cannot be seen in SSMR so the connections appear to be generated by Power BI.

Has anyone seen this and can they be switched off?  It's possible they are useful connections and I sometime merge the specific tables together but I can't have the data model changing itself when our system goes through an upgrade.

For example SO_Header is a separate table to SO_Detail.  Crystal shows them separate, Power BI included the Detail table when the Header table is imported in isolation.

Help please.

[AlexG14]

Excellent, that does seem to be the problem.  Do you know how I can switch that off for existing models where that has been selected?

THank you

[DataInsights]

There may be an external tool that will allow you to change that setting. Otherwise, you'll have to manually change it in each model.

[DataInsights · Accepted solution]

@AlexG14,

Try clearing the Include Relationship Columns setting: