Power Query automatically joining tables?

[tgeels123]

Hello,

I'm pulling in a table using an ODBC connection to our Microsoft SQL server. Why are all related tables automatically being pulled in? Read somewhere this causes HTTP calls for each row in the table you are expanding, is that true? How do I fix this

[tgeels123]

@AlexisOlson Thank you for your reply! Do you know how to change this from Excel Power Query? Doesn't seem like those options are available there.

[Anonymous · Accepted solution]

Hi @tgeels123 ,

Data -> Get Data -> Query Options -> CURRENT WORKBOOK -> Data load.

Best Regards,
Gao
Community Support Team

If 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

[AlexisOlson]

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.

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships#au...