PowerBI Service刷新数据集报错DM_GWPipeline_Gateway_MashupDataAccessError

我创建了一个整合SharePoint List数据与通过ODBC连接获取的A/S 400数据集的PowerBI数据集，该数据集在PowerBI Desktop中运行正常。但发布报表并在线刷新数据集时遇到问题，刷新时出现如下错误：

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The column 'DisplayName' of the table wasn't found."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"DisplayName"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: ThirdPartyCapacity.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 54dc8d30-36e9-46e4-a17e-b233e8eb8ce0
Request ID: 5dd72ecb-2cf2-6082-a9a9-9c8ced7027f7
Time: 2023-07-20 11:11:32Z 

已排查确认以下信息：

• A/S 400数据通过本地数据网关（on-premise data gateway）获取，该网关在其他报表中运行正常
• 数据集所有者拥有SharePoint List的访问权限，不仅具备编辑项的权限，还能编辑列表，可正常打开并操作该列表

内容的提问来源于stack exchange，提问作者pderaaij