Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

My Power Bi refreshing with SharePoint is extremely slow

I have my Power Bi linked to my SharePoint to refresh with live data but unfortunately it's around 26MB to refresh and it takes 35 minutes. Surely there has to be a way to cut down the refresh time. ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

Expand operation is going to cause additional requests to be sent to SharePoint, which is going to slow down the refresh. In your scenario, cache the results of SharePoint using the Table.Buffer function as described in this similar thread and check if the refresh is faster.

Regards,

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
9 years ago

Would it speed it up if the SharePoint dataset link was into Table 1 in PBI Desktop complete unaltered and 'as is'......  and then create a calculated Table 2 within PBI Desktop?

 

I'm not sure of the architecture inside the PBI as to whether this approach would segregate the download task (to/from SharePoint) from the transform task (entirely within PBI Desktop).....