Forum Discussion
Combine Tabular Models
I would like to combine two tabular models (eg company 1 and company 2) with the exact same solution (tables columns, measures, relationships etc) into one tabluar model from where we build reports a...
Hi Anonymous
If I was about to do this I would create a single tabular model from the multiple data warehouses. This would allow me to satisfy the requirement for both the holding company as well as country companies.
I would do this in Power BI desktop and then publish this to the Power BI Service.
hi
Thank you for the response.
How would you combine the different DIM and FACT tables in Tabular Model project?
Combine the DIM's and FACT's from the two data warehouse databases using Power Query?
Combine them using a new combined data warehouse database with views of the two underlying databases DIM's and FACT's?
Other methods?