Forum Discussion
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..
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
- 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
3 Replies
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
- 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