Any way to create one big Data model?

[Anonymous]

I'm struggeling with some issues. Our organizations has multiple data sources, but not from within the same domain.

Table1 and Table 2 are accessable in Domain 1 and Table 3 is accessable in Domain 2. I need to create a datamodel by using all of these three tables. 

I've setup two data gateways, so there shouldn't be an issues from accessing both domains for the Power BI Service.

How can I combines these three tables in a data model? Do I have to use dataflows? I can't create this in Power BI Desktop.

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

For your case, you'd better move the data all into one domain, since you could use a workaround to get all data into one pbix file, but when refresh the dataset, they need to run at the same time. so you'd better move the data all into one domain.

Regards,

Lin

[GilbertQ]

Hi there

As far as I am aware I am not sure how you would combine data from different domains in one model in Power BI Desktop. I would suggest moving the data all into one domain.

This will certainly simplify getting your data.