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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
marktvc
Helper I
Helper I

Merge data without loading both tables

Hi All,

 

I looking for an option to load data from to SQL tables in to one FACT table withouth having to load the second table.

 

I have used the "Merge Query" option, but that requires the second table to be loaded.  Is there code which can be added to the Advanced editor or in custom columns

 

An example of what I'm looking to achieve

 

Table 1

UIDFnameSname
001JohnSmith
002JaneDoe
003MikeJones

 

 

Table 2

UIDTable1UIDQual
500001BSc
501002Dip
502003N/A

 

Desired outcome is only one Fact Table:

UIDFnameSnameQaul
001JohnSmithBSc
002JaneDoeDip
003MikeJonesN/A

 

The primary reason for this is there is a lot of data in Table 2 which is sensitive and prefer not to have loaded in anyway shape or form.

 

 

 

 

 

1 ACCEPTED SOLUTION
Jimmy801
Community Champion
Community Champion

Hello @marktvc 

 

what is wrong in using the merge? However you have to load the second table in one way to other. And even if you merging both tables, and extracting only one column of your second table, Power query will not load all the second table but only the columns needed. How is the performance?


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@marktvc 
You cannot not merge without having both tables in power bi, the workaround is only if you can merge the tables in datasource e.g. SQL database or Excel, then load the merged table in power bi.

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Jimmy801
Community Champion
Community Champion

Hello @marktvc 

 

what is wrong in using the merge? However you have to load the second table in one way to other. And even if you merging both tables, and extracting only one column of your second table, Power query will not load all the second table but only the columns needed. How is the performance?


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors