PowerBI ExportTo API书签状态转换错误求助

我通过服务主体在React应用中集成PowerBI报表，调用ExportTo POST API导出PPT/PDF时遇到格式错误。相关代码如下：

let result = await fetch(
  `https://api.powerbi.com/v1.0/myorg/groups/${data.workSpaceId}/reports/${data.reportId.id}/ExportTo`,
  {
    method: "POST",
    headers: headers,
    body: JSON.stringify(formData),
  }
);

formData = {
  format: "PPTX",
  powerBIReportConfiguration: {},
};
formData.powerBIReportConfiguration["identities"] = [
  {
    username: data.user.email,
    roles: ["RLS"],
    datasets: ["xyz"],
  },
];
formData.powerBIReportConfiguration["pages"] = [{ pageName: data.page }],
formData.powerBIReportConfiguration["defaultBookmark"] =
  data.bookMark.body.state;

使用report.bookmark.Capture()和report.bookmarksManager.applyState()获取并应用书签状态后，添加到formData里触发错误：

Error converting value "H4sIAAAAAAAAA+VZbW/bNhD+K4G+dAOcgqJtvfRbXlqsWLoGcZFhGIKBIs82W1nUKCqJF/i/70hKcfySxk7aJfWCILHIu+PdPXfH8+kmELIqczb9jU0geBMcKvVlwvSXvTDoBMXimkh6UchoN+YJBxqydBhRpFKlkaqogjc3gWF6BOZcVjXLrUBc/POiE7A8P2Uj+2R0DZ2gBF2pguXyH/C0uDPEvzDrBHBd5kozK3JgmAEr9hLp8RlVCV938UTGjbyEAXDjV8+gVNq0z51gKHODLJY1m769LjWqcdNa885tCg5dkvZImIQRzwjtQo8gp5mWluYIDx4pLTnLb8VZaeetIrQTvNNq4uQ2nrOUbwsjzRQfThSyHqOUTyzL4S8WQxhRHu5nrE/20Yt8P4ko3U+BZP0+gRB/kf2TO53M0GW/j0GDE3+kCiG9oXiWMvaftQmqqll8XyyuVQ1fXk+KVeqBqjWHMxjOH5z2M3T+qVaIjbPgD2Aa11CVc5bXDkkUeiLRE+gU6wu7jIRFnVvmi4uZ/bnwEN457xeJHJqPpydwCfmqPrf7q1utOudMSx8RjbpftekWBOt/Z1aD0K2YYMHSD6owY0d3RxXHvDdfsNuNAa1rOsFYXR1pQEIRvAk7AWd8DOJ4nk8eCCmsVhXHA9+7j0dqUqIqldd9/vSrLHCf2IOGxm9tAOGTYm496J3gTI7GToX7AZ9ZusXi8dNhzoovPwcYBTYOKp+QLg8XU9TmtEt8DG7DZNEkK4mo6JPekERhnyd9QggQu74+n5tcPRCXrOAIwXLgHYxGGkasPXDRhdu5dsByBHPJWW5x72Ci6sK4vXd10ZhHlqODzDo364sLPFWtT6C1NEpPl/U7g5Hl/g9V+agF6GU1jsasKCBfo4eLEVmM8uYWmIeFL4TBhJX2fsk+Y9hY9Gdt6Ufxn+8EV2PGdPO6t60LL1y0D2MQ0E8JZ4ywkPBuwuIH4/NrPt692jhnuC/m/u/5+q2ThCEtsmuzfarsbvj5fI2jbMgT1gdOe1TwKAQSPv4++QCsqvXGJrbkS0jXFWjXiT4Cas60WETZCgnDnohFL6UsAp4lPIn6ya7cmo9wCT7YDDv0IX4sddtzYM/+9gWZamMUwUu6kGZpSkIh+hmlEVD6IsBDO0TNzUqhauvHoj30x4Vua0M9cHGvB8Mo4zzkMWGUJiyFlwzc3eVdxu1eO5t8i0k3gShK0qgbQULitOe/nn3NYgPXJlPXq6U3EUnCoU85JbxP0yiK04dL7/P2Ez9cI/ZgPJYS1vY/P8o18J2+1DwQF75DSskwZWmGWYEXUBKFnMZP6JB2r59cO+rZICarXHL0/t2IDCagR86gERR+poIuLb1yEqq52xc/PfvM8XnHi5SEyUk7X3QzRuQRzLA17pso4RwMLmDXint1jBxCXRWv/Ajrwo6p8rY2rEisDNZpM3BQDxzdA/LdGLsRPbu/CIXLRWhnU+fe+naL+w4bb+uEnwr7tw7NbPi9gcluzobbbF0zHLZbgU8K0eMU+64sITROCelxEmUvonfeobnR99Bjk69Kz6bFoM74/Yps0EVeKuOyY6M52pm62uIe3MaD38UdWIS91McovVk76UBlhRXlXtz6k7TK3SfvMFQjtxXS7/1dg57iYW6/MeP1rSuQVlanEuUL/97YumYty11THReal7OyahlXBCGRVv5NqhTgzGxvI/tyq7m6M5EBpMMwTrrdvkiyLs2eUKW+zfTwyBYhjc3J3v7euYQrPOgbzRFdxV7XraraVCXjcMoKWNMhOdAFiK36otnsXwx1o/Z4IAAA" to type 'Microsoft.PowerBI.ServiceContracts.Api.V1.PageBookmark'

环境：power-bi-client版本^2.22.0，后端使用Express和Node.js

错误核心是：report.bookmark.Capture()返回的state是Base64编码的压缩JSON字符串，但ExportTo API的defaultBookmark字段要求传入PageBookmark对象，而非直接的编码字符串。

修复步骤： #

1. 解码Base64字符串为原始二进制数据
2. 解压缩Gzip数据得到JSON字符串
3. 解析JSON为对象，提取API需要的书签结构
4. 将整理后的对象赋值给defaultBookmark

修改后的代码示例： #

// 新增解码和解压缩工具函数（需要引入pako库处理Gzip）
import pako from 'pako';

function decodeBookmarkState(encodedState) {
  // 解码Base64
  const binaryString = atob(encodedState);
  const bytes = new Uint8Array(binaryString.length);
  for (let i = 0; i < binaryString.length; i++) {
    bytes[i] = binaryString.charCodeAt(i);
  }
  // 解压缩Gzip
  const decompressed = pako.inflate(bytes, { to: 'string' });
  // 解析为JSON对象
  return JSON.parse(decompressed);
}

// 构建formData时处理书签状态
formData = {
  format: "PPTX",
  powerBIReportConfiguration: {},
};
formData.powerBIReportConfiguration["identities"] = [
  {
    username: data.user.email,
    roles: ["RLS"],
    datasets: ["xyz"],
  },
];
formData.powerBIReportConfiguration["pages"] = [{ pageName: data.page }];

// 处理书签状态
const decodedBookmark = decodeBookmarkState(data.bookMark.body.state);
// 提取PageBookmark所需的结构，通常包含visualizations等字段
formData.powerBIReportConfiguration["defaultBookmark"] = {
  visualizations: decodedBookmark.visualizations,
  // 若有其他必要字段，可从decodedBookmark中提取
};

// 发起请求
let result = await fetch(
  `https://api.powerbi.com/v1.0/myorg/groups/${data.workSpaceId}/reports/${data.reportId.id}/ExportTo`,
  {
    method: "POST",
    headers: headers,
    body: JSON.stringify(formData),
  }
);

注意事项： #

• 需要安装pako库处理Gzip解压缩：npm install pako
• 不同版本的power-bi-client返回的书签结构可能略有差异，可打印decodedBookmark查看具体字段，匹配API要求的PageBookmark结构
• 确保服务主体拥有足够的权限访问报表和导出操作

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