Forum Discussion
Any way to create one big Data model?
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.
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
2 Replies
- GilbertQ
Super User
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. 
v-lili6-msftCommunity Support
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
