combine two identical dimension tables from two different datamodels without using power query

[Anonymous]

I have got two different datasets with two different datamodels. This two datamodels has multiple identical tables in both datasets. For example, dataset 1 en dataset 2 both has a dimension table 'date'. Every column in both tables are the identical. I dont want both tables to exist. I just want one dimension table 'date' to exist and this one dimension table has to be connected to all fact tables from the different datamodels. The problem is I work in a company and they didnt give me the acces to power query so I cant make a query that merge or combine this two dimensions in one table. Neither can I change the relations from the already existing relations between the facts and the dimensions. I can only make new relations. Is it possible to combine/merge this tables with dax or direct query? I already tried to get a relationship between the dimension tables 'date' from both datamodels by manage a relation between both primary keys from both dimensions, but when I do that it will take hours for PowerBI to calculate the query's and show the visualisations. Can anyone help me out with a better solution without really touching the performance of the time to calculate queries
?

[Anonymous]

hi @Anonymous 

you can try the union DAX function : UNION – DAX Guide

If this post helps, then please consider accepting it as the solution to
help other members find it faster, and give a big thumbs up. 🙂

[Anonymous]

Not really what I am looking for. This function combines two different tables and returns a table with every row from both tables. I am looking for something that combines two identical tables in one table within the datamodel.