none
Refreshing of data not possible RRS feed

  • Question

  • I have a query that loads an Excel file to the data model.

    Now after modifying a column by adding a prefix to the text i get an error massage when loading the data to the model.

    "OLE DB or ODBC error: The Query "xxxxxx" or one of its inputs was modified in Power Query after this connection was added. Please disable and re-enable loading the Data Model for this query.."

    I had similar errors also when trying to load a modified query from an Access DB. I just added an additional filter in that case.

    I saw that other users had this problem as well in the past already. Is there a fix?

    I Use Excel 2013 and the latest power query version.

    Thanks!

    Martin

    Wednesday, August 10, 2016 3:37 PM

Answers