none
"The Data Model table couldn't be refreshed" RRS feed

  • Question

  • I had to change the path of the source of several tables in my Power Query data model. However now I get the error

    "The Data Model table couldn't be refreshed"

    [Data source.Error] Could not find part of the path

    The data sources show 2 lines the old path and the new path. However I can't find anywhere else to change the path. I have seen references that this is a known issue with workaround but the link to the work around does not work :(

    https://answers.microsoft.com/en-us/msoffice/forum/all/refreshing-an-excel-table-query-results-in-this/85ce58ca-c369-4f82-bb2c-63f415e5d9f6

    Anyone have advice?

    thanks

    Alan

    Monday, March 9, 2020 2:44 PM

Answers

  • But the error is specifically pointing to the Query because it says it couldn't refresh the connection.  I found another person saying to go in through the Data Source settings.  Open the Query in question, click Data Source and see if it is correct there.

    Monday, March 9, 2020 8:16 PM

All replies