cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Add the same from sql into PBI twice

@route217 

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

Highlighted
Super User IV
Super User IV

Re: Add the same from sql into PBI twice

@route217
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

 


______________


Has this post solved your problem? Please mark it as a 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.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


excelwithallison.com

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Add the same from sql into PBI twice

@route217 

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

Highlighted
Resolver I
Resolver I

Re: Add the same from sql into PBI twice

Many thanks

Highlighted
Super User IV
Super User IV

Re: Add the same from sql into PBI twice

@route217
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

 


______________


Has this post solved your problem? Please mark it as a 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.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


excelwithallison.com

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors