Forum Discussion

tgeels123's avatar
tgeels123
New Member
3 years ago
Solved

Power Query automatically joining tables?

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

tgeels123's avatar
tgeels123
New Member
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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