Power Query Refresh Issues when additional odbc connection is present in PowerPivot RRS feed

  • Question

  • Hi technet team,

    I'm coming across this issue more frequently and in more workbooks that I could imagine. I have issues refreshing the connection in power-query and connections in powerpivot (odbc connections mostly) directly together. I can refresh the power query separately and then refresh all other conections in powerpivot separtely but when I do then together I get some cryptic errors (Out of line object...).

    Below is the scenario I'm using the works.

    1. disabled "refresh on refreshAll" for all power-query connections.
    2. use refreshAll to refresh all powerpivot and/or excel workbook connections. 

    3. the, refresh all power query workbooks one by one (Is there a way to refresh all powerQuery workbooks together?)

    is this a known issue, it it is is there a fix for it?

    Thursday, October 16, 2014 8:39 PM


All replies