Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
UID | Fname | Sname |
001 | John | Smith |
002 | Jane | Doe |
003 | Mike | Jones |
Table 2
UID | Table1UID | Qual |
500 | 001 | BSc |
501 | 002 | Dip |
502 | 003 | N/A |
Desired outcome is only one Fact Table:
UID | Fname | Sname | Qaul |
001 | John | Smith | BSc |
002 | Jane | Doe | Dip |
003 | Mike | Jones | N/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.
Solved! Go to Solution.
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
@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.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |