Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

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

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
Schermafbeelding 2022-03-16 132206.png?

2 REPLIES 2
Anonymous
Not applicable

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 applicable

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. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.