Power Query incredibly slow

[Corentin10]

Hi everyone,

Since yesterday, my PBI is extremely low to refresh. It takes about 30 minutes to be refreshed while it took a few seconds a few days ago. I noticed that it was specifically the "join" and "group by" steps that caused the problem in Power Query. However, I only have 150 rows so I really don't understand the root of my issue. It was working perfectly and I have not changed anything. Any help/recommendation whould be highly appreciated !

Thanks in advance !

[Anonymous]

Hi @Corentin10,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

HI @Corentin10,

I'd like to suggest you take a look to the following links to know the buffer functions and how to use improve the M query processing performances:

New Options For The Table.Buffer Function In Power Query 

Solved: When to use Table.Buffer - Microsoft Fabric Community

Regards,

Xiaoxin Sheng

[Corentin10]

Hello,

Thanks for your answer ! However, it does unfortunately not solve my problem. It is still super slow. Even adding a simple step like adding a column takes a while (and I only have 134 rows).

Any idea/suggestion ?

Thanks again !

[VijayP]

@Corentin10 
Try clearnin Cache from the Data Load option as shown in pic, and try again it should be faster than earlier

[Corentin10]

Hi @VijayP ,

Thanks for the suggestion. I had however already tried and it did not change anything 😣

It remains like this : 

[Corentin10]

Actually, even my connection to the data source (Sharepoint) is super slow