Forum Discussion

jnickell's avatar
jnickell
Helper V
3 years ago
Solved

Power Query load from Dataflow is excruciatingly slow

I'm a lttle at my wits end with this. Occassionally PowerQuery is very very slow to load previews of data, as in I've seen this before, but recently it's gotten really bad, today is unbearable.  My c...
Need Help
  • edhans's avatar
    edhans
    3 years ago

    Try clearing the cache in Power BI Desktop.


    If that doesn't help, is this on a laptop? Go to Starbucks or someplace else and see if the internet there is better. if that works, there could be a routing issue from your location that is causing a problem, or some other corporate firewall.

    Also, you don't have to wait for the preview to finish to load. Just close Power Query and tell it to save (and apply) the data. Even if it fails the first time, hitting Refresh in Power BI desktop usually clears that up.

     

    Edit: oh, what dataflow connector are you using? Does the Source line say PowerPlatform.DataFlow or PowerBI.dataflow? Whatever it says, switch it out. I personally prefer the PowerBI.Dataflow as for raw speed it is faster, but doesn't allow folding or setting incremental refresh with it.

     




edhans's avatar
edhans
Community Champion
3 years ago

They are, and in fact the Power BI dataflow connector says "legacy" and at some point they will remove the ability to create new connections, but I think we are a LONG LONG way from existing ones breaking. I would set one up with the Power BI connector and see if you can see a speed difference.

jnickell's avatar
jnickell
Helper V
3 years ago

Once I got to the office this morning, I installed the update Power BI had prompted for. 

I was able to get a full refresh completed of my model this morning. It took several (2 at least) hours. I'm going to try and make some lost time right now.

 

Right at the moment I don't want to take the additional time/risk of trying to test the PowerBI dataflow connector, but I will keep that in mind when/if this resurfaces. 


Thanks for taking the time to respond to my cry for help.