问题:本地刷新没问题,在报表服务器刷新报错

    出现错误。
    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中进行合并查询。