Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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?
hi @Anonymous
you can try the union DAX function : UNION – DAX Guide
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.