Query works in Power Query, but fails when loading into Power BI?

Good afternoon all,

Hoping you can help! I created the below code to call from the Tenable.io API which works perfectly in Power Query and I can see the results...

let

    URL1    = "https://cloud.tenable.com/vulns/export",
    Access  = "ACCESSKEY",
    Secret  = "SECRETKEY",
    Body    = "{""include_unlicensed"": false,""num_assets"": 5000}",
    Header  = "accessKey=" & Access & ";secretKey=" & Secret,
    
    Source1 = Json.Document(Web.Contents(URL1,
    
        [ Headers = [ #"X-ApiKeys" = Header ],
          Content = Text.ToBinary(Body)
        ]
    )),

    ExportUUID = Source1[export_uuid],

        URL2    = "https://cloud.tenable.com/vulns/export/" & Text.From(ExportUUID) & "/chunks/1",

     Source2 = Json.Document(Web.Contents(URL2,
    
        [ Headers = [ #"X-ApiKeys" = Header ]
        ]
     )),

    #"Converted to Table" = Table.FromList(Source2, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"asset", "output", "plugin", "port", "scan", "severity", "severity_id", "severity_default_id", "severity_modification_type", "first_found", "last_found", "state", "indexed"}, {"asset", "output", "plugin", "port", "scan", "severity", "severity_id", "severity_default_id", "severity_modification_type", "first_found", "last_found", "state", "indexed"}),
    #"Expanded asset" = Table.ExpandRecordColumn(#"Expanded Column1", "asset", {"agent_uuid", "hostname"}, {"agent_uuid", "hostname"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded asset", each ([severity_id] <> 0))

in
    #"Filtered Rows"

This works fine in Power Query and I can see the table and all the data in the preview window, however when I click "Close & Apply" to load the query into Power BI, I just get the following error: