Tableau数据源通过Hyper API更新无效问题求助

我有一个包含提取文件（extract file）数据源的Tableau工作簿，尝试通过Hyper API更新该数据源。代码执行正常，但Tableau服务器无变化，output.hyper文件出现在项目文件夹，工作簿提示过期但点击刷新无效，请问哪里操作有误？

原代码 #

with server.auth.sign_in(tableau_auth):
        # Get the project ID
        all_projects, pagination_item = server.projects.get()
        project_id = next(project.id for project in all_projects if project.name == project_name)

        # Find the workbook
        all_workbooks, pagination_item = server.workbooks.get()
        print("Workbooks available:")
        for workbook in all_workbooks:
            print(f"Workbook name: {workbook.name}, Workbook ID: {workbook.id}")

        workbook = next(workbook for workbook in all_workbooks if workbook.name == workbook_name)

        # Get the workbook's data sources
        server.workbooks.populate_connections(workbook)
        data_source = next(ds for ds in workbook.connections if ds.datasource_name == data_source_name)

        # Update the data source with the new file
        new_data_source = TSC.DatasourceItem(project_id, name=data_source.datasource_name)
        new_data_source = server.datasources.publish(new_data_source, local_file_path, 
        TSC.Server.PublishMode.Overwrite)

        #  Refresh the workbook to reflect the new data
        server.workbooks.refresh(workbook.id)
        print(f"Workbook {workbook.name} (ID: {workbook.id}) has been refreshed.")
 
        print("Data source updated and workbook refreshed.")

核心错误1：混淆了内嵌数据源与独立数据源 #

你的代码发布了一个服务器独立数据源，但工作簿实际使用的是内嵌在工作簿内部的提取数据源——两者是完全独立的对象。独立数据源更新后，工作簿依然绑定自身内部的旧数据源，自然看不到变化。

核心错误2：刷新操作未针对正确对象 #

server.workbooks.refresh(workbook.id) 仅触发工作簿的常规刷新，但内嵌提取数据源的更新需要直接修改工作簿的连接配置，而非发布新的独立数据源。

修正步骤 #

直接替换工作簿内嵌的提取数据源，通过覆盖发布工作簿来关联更新后的Hyper文件：

修正后代码示例 #

with server.auth.sign_in(tableau_auth):
    # 获取项目ID
    all_projects, pagination_item = server.projects.get()
    project_id = next(project.id for project in all_projects if project.name == project_name)

    # 查找目标工作簿
    all_workbooks, pagination_item = server.workbooks.get()
    workbook = next(workbook for workbook in all_workbooks if workbook.name == workbook_name)

    # 填充工作簿的连接信息
    server.workbooks.populate_connections(workbook)
    # 定位到目标内嵌数据源连接
    target_connection = next(conn for conn in workbook.connections if conn.datasource_name == data_source_name)

    # 关键：将连接指向本地生成的output.hyper文件
    target_connection.datasource_file = local_file_path

    # 覆盖发布工作簿，保留原工作簿的ID与位置
    updated_workbook = server.workbooks.publish(
        workbook,
        local_file_path,
        TSC.Server.PublishMode.Overwrite,
        connections=[target_connection]
    )

    # 触发工作簿刷新，确保数据生效
    server.workbooks.refresh(updated_workbook.id)
    print(f"工作簿 {updated_workbook.name} 已成功更新并刷新")

额外注意事项 #

• 确认local_file_path是Hyper API生成的output.hyper文件的完整正确路径
• 确保你的Tableau账号拥有「发布工作簿」和「刷新数据源」的权限
• 如果工作簿确实使用服务器独立数据源，需在发布时指定原数据源的ID，而非新建DatasourceItem

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