Forum Discussion
Join multiple table take too long to excute
Hi Nardjes
If you only need the final 51 records in the report, I recommend that you use the SQL statement to query the data directly. Use SQL query to make the join. This will send the SQL query to the database and perform the join process there. The performance of the database server may be better than your local computer. This can also avoid bringing too much data to your computer.
Import data from a database using native database query - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Community SupportHi Nardjes
If you only need the final 51 records in the report, I recommend that you use the SQL statement to query the data directly. Use SQL query to make the join. This will send the SQL query to the database and perform the join process there. The performance of the database server may be better than your local computer. This can also avoid bringing too much data to your computer.
Import data from a database using native database query - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
it's work Thank you 🙂
