Importing SQL data to PBI

luckygirl 

You can try this

SELECT *
FROM Alert
WHERE CusID IN (
SELECT DISTINCT CustomerID
FROM Applications
WHERE ProdType = 'A'
);

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Hi luckygirl ,

pankajnamekar25 ,  proposed query efficiently filters the Alert table by selecting customers from the Applications table with ProdType = 'A', meeting your requirement. This method minimizes unnecessary data loading. To enhance performance, please ensure that CustomerID in Applications and CusID in Alert are indexed.

Let us know if further optimizations are needed.
If your issue is resolved, please mark it as the accepted solution. This will help others facing a similar issue.