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. All solutions are welcome. Thanks

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous,

    Do you refresh the data in Power BI Desktop or in Power BI Service? If you refresh data in Power BI Desktop, please disable the following options, and we also need to know what changes you make on the data in Power BI Desktop.


    If you encounter the issue in Power BI Service, please firstly check that how long it takes to refresh in Power BI Desktop.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hello,

       

      I am in Power Bi Desktop. I had Time Intelligence and Background Data both checked and they are now unchecked which has made it faster but still in  the 10-15 min range.

       

      In order to get certain fields in the form I needed I removed other columns, expanded fieldvaluesasText and renamed and removed a lot of columns after that.  Overall is it possible to speed it up to 1-3 minutes ?

       

      Thanks for the help

      • 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,