Forum Discussion
Power Query automatically joining tables?
Hi tgeels123 ,
Data -> Get Data -> Query Options -> CURRENT WORKBOOK -> Data load.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Yes, Power Query is automatically detecting these relationships but you can turn this feature off in the Data Load settings.
Microsoft documentation:
-
Import relationships from data sources on first load: This option is selected by default. When it's selected, Power BI checks for relationships defined in your data source, such as foreign key/primary key relationships in your data warehouse. If such relationships exist, they're mirrored into the Power BI data model when you initially load data. This option enables you to quickly begin working with your model, rather than requiring you find or define those relationships yourself.