Power Platform Community Forum Thread Details

Hello,

Trying to create a gallery of items based on a join of 2 tables (source SQL Server).

Table 1: 670k records

Table 2 (aggregated to Table 1): 1.1m records

Constraints:
1. Filtering Table 1 data
2. Filtering Table 2 data

How should this be done? The ways I've thought of are slow: Currently have a lot of lookups.

Thanks

Categories:

Joining Tables in Gallery - One (670k records) to Many (1.1m records)