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
Anonymous
Not applicable

Add the same from sql into PBI twice

Hi Experts

 

I want to add table A twice from an Sql dB, 

1. Once to use as FACT table and

2. To use as bridging table by taking only distinct values based on ID field.

 

What are my option and best method/approach to use..

2 ACCEPTED SOLUTIONS
PaulDBrown
Community Champion
Community Champion

@Anonymous 

Just import it once, and then use the "Reference" option (right-click on query itself for the table in Power Query).

a new query will be created, where you can delete unnecessary columns and remove duplicates for the column needed. Rename this new table as a Dimension table.

Load and create the One-to-Many relationship in model view





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

@Anonymous
If Paul's solution works for you, please mark it as a solution so others can find it easily.

@PaulDBrown do you know what the performance differences are on Reference vs Duplicate? https://radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics/?ref=818

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

@Anonymous 

Just import it once, and then use the "Reference" option (right-click on query itself for the table in Power Query).

a new query will be created, where you can delete unnecessary columns and remove duplicates for the column needed. Rename this new table as a Dimension table.

Load and create the One-to-Many relationship in model view





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Many thanks

@Anonymous
If Paul's solution works for you, please mark it as a solution so others can find it easily.

@PaulDBrown do you know what the performance differences are on Reference vs Duplicate? https://radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics/?ref=818

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

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.