Skip to main content

    Power BI

    New

    Getting data from SharePoint list is very slow

    Vote (9) Share
    Shawn Keene's profile image

    Shawn Keene on 17 Oct 2019 23:41:53

    I have found that retrieving info from SharePoint Online (O365) with PowerQuery is incredibly slow, specially if you expand any person column like Author/Editor of an entry. Is there any way to speed this up?

    Comments (2)
    Shawn Keene's profile image Profile Picture

    7a5a989f 36db-ea11-a813-000d3a9b112e on 10 Aug 2020 18:25:59

    RE: Getting data from SharePoint list is very slow

    Agreed. Takes hours if you have to expand multiple columns. Please fix this!

    Shawn Keene's profile image Profile Picture

    d4900564 e4ed-4dfd-b016-1e562985bc66 on 06 Jul 2020 00:03:36

    RE: Getting data from SharePoint list is very slow

    Crazy slow, I have a list with 70K rows and it's so slow to download in powerquery. It makes it impossible to report on the list data.