The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
Try clearing the Include Relationship Columns setting:
Proud to be a Super User!
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
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.
Proud to be a Super User!
Try clearing the Include Relationship Columns setting:
Proud to be a Super User!