Getting errors when trying to connect to Sharepoint RRS feed

  • Question

  • When I try to combine files from SharePoint through Power Query, I get the below error. I've been through several entries on this in other forums, but none of the solutions seem to work for me. Can someone help me figure out what I'm doing wrong?

    Excel couldn't refresh the table 'Query1' from connection 'Query - Query1'. Here's the error message from the external data source:

    The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source.

    More Details:

    "OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table.."

    "An error occurred wile processing table 'Query1'."

    "The current operation was cancelled because another operation in the transaction failed."

    All of my files are formatted the same. The data is contained in a table that is named the same in each file and is on a tab of the same name and has the same columns in the same order.

    Friday, April 3, 2020 9:33 PM