Hi
The current action 'Transform date using Power Query' for On Premise SQL connections, seems to suggest that you can use 2 sources\SQL Instances, but I cannot get this to work and can't find any documents that explain how it can be done
So to be clear;
I have a SQLServer1 and DB1 and SQLServer2 and DB2
I want to merge data from Table1 in DB1 to Table2 in DB2
In Power Query you can create extra Parameter for another server and database by simply adding new parameters, then you can also put these neatly into a new group , and when you right click on that parameters group you can choose to select another data source , as below
But this always defaults back to the original data source and database, so the one that was chosen when you added the action 'Transform data using Power Query' in the first place. It doe snot let you select from another SQL instance or in any way use your new parameters
I have changed the option ' Allow combining data from multiple sources...' as highlighted below under Options\Project Options
Is it possible to do this?
The work around is really not usable, that is where I set 1 of the SQL tables as an array that looks up the other SQL table, also as an array. Every record of array 1 must lookup every record of array 2 to see if they match, then if they don't put the record in a new array, which is basically a list of unmatched records. As my volumes are quite high, the flow takes a long time and is resource heavy
If Power Query in flow could make a link between the 2 instances, all I would need is a 'left other join' on the merged tables, then I could easily filter on unmatched.
