Forum Discussion

Amirmosh's avatar
Amirmosh
Regular Visitor
3 years ago

Loading connection only queries to a different workbook data model

Hi,
I have 2 connection only queries, each in a different workbook & I would like to load them to a data model.
1) Each query is in a different workbook.
2) These queries are a result of other queries in the workbook that they are stored.
3) The queries are not loaded as a table, since they are very big.

I would like to know if there is a way of loading them to a data model.

Thanks, Amir

Need Help

4 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi Amirmosh ,

    Have you tried to load from current connection only by right clicking on the connection only query that has been created and select load to.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Amirmosh's avatar
      Amirmosh
      Regular Visitor
      3 years ago

      Hi,

      I will try to explain differently: 

      I have two queries already loaded as connection only,each query in a different workbook.

      I would like to load them to load them both to a some data model.

      Meaning that I will be able to see them both in the data model.

      How can I manage doing so ?

      Thanks, Amir

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi Amirmosh 

     

    The 'Data Model' is part of the Excel file in which the query resides.  Whilst 'Data Model' refers to a way of gathering and storing data in Excel, each Excel file has its own Data Model.  There isn't a single Data Model that is shared or acccesible across workbooks.

     

    So if you have 2 queries in 2 separate workbooks, loading each one to the Data Model will mean they are still in their own respective workbooks.  You won't be able to see both queries or their resultant tables from a single Data Model.

     

    Regards

     

    Phil

    • Amirmosh's avatar
      Amirmosh
      Regular Visitor
      3 years ago

      Hi Phil,

      Is this true for connection only queries?

      For example, If I have a loaded query to a table in a different workbook

      And I use "existing connections" in order to connect it to another WB

      then it is possible to load the 2 queries to the data model