MacBook Pro中Excel Web Power Query无法刷新，报Web.Page导入错误求助

我在Windows电脑上通过Web Query从网站获取数据，保存文件后发送到MacBook Pro，尝试刷新Excel表格时出现错误：

[Expression.Error] The import Web.Page matches no exports. Did you miss a module reference?

以下是在Windows系统上可正常运行的Power Query代码：

let
    SvcUrl = "https://accounts.zoho.com/oauth/v2/token?refresh_token=****.******47892*******************&client_id=*********&client_secret=*********&redirect_uri=https://www.google.com&grant_type=refresh_token",
    Content = "{}",
    Response= Web.Contents(SvcUrl, 
    [
        Content=Text.ToBinary(Content),
        Headers=[#"Content-Type" = "application/json"]
    ]),
    Json = Json.Document(Response),
    AccessToken = Json[access_token],
    AccessTokenHeader = "Zoho-oauthtoken " & AccessToken,
    Source = Json.Document(Web.Contents("https://www.zohoapis.com/invoice/v3/customerpayments", [Headers=[Authorization=AccessTokenHeader, #"X-com-zoho-invoice-organizationid"="76077****", #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"]])),
    customerpayments1 = Source[customerpayments],
    #"Converted to Table" = Table.FromList(customerpayments1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"payment_id", "payment_number", "invoice_numbers", "date", "payment_mode", "payment_mode_formatted", "amount", "bcy_amount", "unused_amount", "bcy_unused_amount", "description", "reference_number", "customer_id", "customer_name", "created_time", "last_modified_time", "last_four_digits", "gateway_transaction_id", "payment_gateway", "bcy_refunded_amount", "applied_invoices", "has_attachment", "documents", "custom_fields_list", "tax_amount_withheld", "payment_type", "settlement_status"}, {"Column1.payment_id", "Column1.payment_number", "Column1.invoice_numbers", "Column1.date", "Column1.payment_mode", "Column1.payment_mode_formatted", "Column1.amount", "Column1.bcy_amount", "Column1.unused_amount", "Column1.bcy_unused_amount", "Column1.description", "Column1.reference_number", "Column1.customer_id", "Column1.customer_name", "Column1.created_time", "Column1.last_modified_time", "Column1.last_four_digits", "Column1.gateway_transaction_id", "Column1.payment_gateway", "Column1.bcy_refunded_amount", "Column1.applied_invoices", "Column1.has_attachment", "Column1.documents", "Column1.custom_fields_list", "Column1.tax_amount_withheld", "Column1.payment_type", "Column1.settlement_status"})
in
    #"Expanded Column1"

解决方法 #

• 更新Mac版Excel：确保MacBook Pro上的Excel为最新版本，旧版Power Query（Get & Transform）可能存在函数兼容性缺陷。
• 重新创建查询：不要直接打开Windows保存的文件，在Mac版Excel中新建空白查询，粘贴代码重新创建，规避跨平台文件格式带来的隐性模块加载问题。
• 检查网络权限：确认Mac可正常访问Zoho的API地址（https://accounts.zoho.com和https://www.zohoapis.com），关闭干扰性代理或防火墙，网络异常可能间接触发模块引用错误。
• 重置查询缓存：进入Excel「数据」选项卡，打开「查询和连接」面板，删除现有查询后重新导入代码，清除缓存冲突。

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