Loading connection only queries to a different workbook data model

[Amirmosh]

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

[PhilipTreacy]

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]

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

[v-yanjiang-msft]

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]

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