Power Platform Community Forum Thread Details

Hi there, I'm fairly new to using SQL Server so I apologize if this has an obvious answer, but I have a flow that needs to pull in data using a SQL Server query that joins tables from 2 different databases on the same server. (Also this is Azure SQL Server, not on-prem). It looks like the standard action below only supports 1 database:

I know I have the option to bring in the data from both tables & join them in flow, but I gather that tends to not be very performant/fast, hence trying to find a way to let SQL Server do the processing / joining before pulling into flow.

Thanks!

Categories:

General topics