问题:本地刷新没问题,在报表服务器刷新报错
出现错误。
Several errors occured during data refresh. Please try again later or contact your administrator.
SessionID: 128441db-1da8-444b-aaa2-554fe43b045f
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, 已添加了具有相同键的项。.
[1] -1055784828: The database operation was cancelled because of an earlier failure.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
原因:两个连接数据库的查询,不能在PQ中进行合并查询。