Building up a new dataset and including another dataset

[martinobermayr]

Hi folks.

I have a existing Dataset called "BI", that includes my customers, sales, hr and many more:

Now i would like to build up a new, separate Dataset called "BI Potential" into which i will insert a huge SQL-DB with market-data. I want to outsource this because otherwise i think i could get performance problems.

So far so good. Of course now i will provide that i can compare and combine both my existing customers (from Dataset "BI") with my market potential (from the new Dataset "BI Potential")

I thought i can simply include the existing "BI"-Dataset as a Datasource into the new Dataset and i found out that there is a possibility doing this by doing this:

->

->

Now i can see all tables both from "BI"- and "BI Potential"-Dataset:

But there is no possibility in the query editor making a combined table out of Table "Kunden" (= customers) from Dataset "BI" and table "HEROLD" (= potential customers) from the current Dataset "BI Potential", because in the editor i only can see the "BI Potential" tables:

->

Can you please tell me if i am doing something wrong or if there is a way to solve this?

Thank you very much in advance.

[ToddChitt]

It sounds like you have data from two different  sources and you want to bring them together (like a UNION, not a JOIN), is that correct? If so, let each table come into the model. Then create a DAX table using the UNION function in DAX. Hint: Make sure the two source tables have the same columns in the same order or you may get strange results.