power query online is too slow

[cagatay]

Hello,

I use power query online (dataflow) with the pro account in my previous company for a long time but at this company, we buy per premium and when I open the power query online and trying to organize my data but I'm only waiting for too long times the performance of power query page is really bad right now. 

what can I do 

[v-easonf-msft · Accepted solution]

Hi, @cagatay 

There are  lot of parameters that may impact on the query performance .This kind of problem is difficult to identify the exact reason.

When querying large databases with Power Query, the design of the query itself sometimes causes long waiting periods because of background loading activities.In addition ,it may also depend on the speed of the network connection, the location of the tenant ,the type of data source, the way of query conversion, etc.

For some relevant suggestions, you could try to refer to Any way to speed up really slow refresh times in Power Query? | Power Query | Excel Forum  for details.

Best Regards,
Community Support Team _ Eason

[cagatay]

can anyone hlep about it