Connecting to SharePoint Survey - Power BI RS (January 2024)

[aben_PBI]

For a couple reports we have, I have connected to a SharePoint survey. To access the data, I load the data under the "SharePoint List" data type. However, we have noticed that on the Server, it is taking around 3.5 minutes to refresh vs other reports that take 10 to 20 seconds (and these faster reports have even more data froming from SQL servers and Excel files combined).

Is there an optimized way to pull in this data without impacting the server so much?

[christinepayton]

3.5 minutes isn't extreme enough to worry about in my opinion, but if you'd like to speed it up you can remove any columns you're not using in your first Power Query steps after the navigation. Steps like remove columns will fold to the source, so it'll pull less data and be less of a load. SharePoint sources usually have at least a dozen back-end columns that you don't necessarily need that can be removed. 

[aben_PBI]

We have already removed all unnecessary columns. What I am noticing, is that the data loads in about 100kb increments every second, which then can take up to a few minutes to load. I just think it should be faster.