Join multiple table take too long to excute

[Nardjes]

Hello I am a beginner in power Bi

I have a sql query that allows me to make the join between 4 tables (with inner and left join)

In Power Query I select the first table and i make the merge with the 2nd table but this action takes a lot of time and never excutes knowing that the result of the merge is 3 million records and each time I make merge it decreases, the final result is 51 records.

My problem is that the merge takes a long time and never runs! 

- I kept only the necessary columns

- I applied the filter to minimize the rows 

- I unchecked "Allow background data previews to be downloaded".

My RAM is 16GB.

Any help would be appreciated.

[v-jingzhang · Accepted solution]

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.

[Nardjes]

it's work Thank you 🙂