I have a requirement to merge live data with datalake data, so have used LookUpRow function to map the records. But the performance of the report is slow after adding LookUpRow.
Is there an alternate option to fetch attributes from datalake with better performance.
Report is taking 1 minute to load, without Lookuprow it is loading in 1 second.