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

Great. If you do test the Power BI connector and it works better, and you need help swapping out the M code, let us know. It is a 30 second code swap in the Advanced Editor with no need to redo any other transformations.

In the mean time, could you mark one or more as the solution that at least guided you on this so this thread can be marked as closed? Thanks, and have a good weekend!

jnickell's avatar
jnickell
Helper V
3 years ago

Could you outline what you'd call the 30 second switch between Power Platform dataflows and PowerBI dataflows.

I'm still having issues with this (have been focused on my AV) which I thought was causing the issue. haven't got to the cache clearing and remapping the dataflows yet.