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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NaeemShahzad123
New Member

Reference Table Or Duplicate Table

In query editor I have created dimension table from sales fact table using reference table option. When I deleted a column in sales fact table which was also present in dimension table, it causes an error in dimension table as it was taking that column (deleted one) from sales fact table. So is it means that we should use duplicate table option instead of reference table option while creating dimension table? What is the best practice , use duplicate table option of reference table option?

1 ACCEPTED SOLUTION
CharbelArmaleh
Resolver II
Resolver II

Hello,

in your case it is best to use duplicate query cos you need to create a dimension table using your source fact table as ref

 

Did I answer you Question? Do not forget to mark it as solution!

View solution in original post

2 REPLIES 2
CharbelArmaleh
Resolver II
Resolver II

Hello,

in your case it is best to use duplicate query cos you need to create a dimension table using your source fact table as ref

 

Did I answer you Question? Do not forget to mark it as solution!

Thanks 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.