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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.