power query auto refresh in the background RRS feed

  • Question

  • i am trying a find a way to auto refresh power queries in Excel in the background

    currently am pulling data from sharepoint and it takes too long to refresh the data

    I can't use excel while refresh is happening. any suggestions?

    Thanks in advance folks :)


    Monday, September 16, 2019 11:44 AM


  • Open a second instance of Excel. From memory, hold Alt, right click in the Excel logo in the task bar and then you can open a new instance.

    Self Service BI Expert using Power Pivot

    Tuesday, September 17, 2019 12:05 PM