Power Query incredibly slow

Question

Hi everyone,&nbsp;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 !&nbsp;Thanks in advance !

anonymous · Answer

HI&nbsp;Anonymous,
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&nbsp;
Solved: When to use Table.Buffer - Microsoft Fabric Community
Regards,
Xiaoxin Sheng

anonymous · Answer

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 !

anonymous · Answer

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

vijayp · Answer

Anonymous&nbsp;Try clearnin Cache from the Data Load option as shown in pic, and try again it should be faster than earlier&nbsp;

anonymous · Answer

Hi&nbsp;VijayP&nbsp;,Thanks for the suggestion. I had however already tried and it did not change anything&nbsp;😣It remains like this :&nbsp;&nbsp;

Forum Discussion

Power Query incredibly slow

6 Replies

Related content

Power Bi Service running incredibly slow

Power Query dates

Data transform using power query

Power BI Service Incredibly Slow.

ayuda en power query