Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.

Power Query output not showing body/value (click to download instead)

  • 1.  Power Query output not showing body/value (click to download instead)

    Bronze Contributor
    Posted Jun 07, 2021 10:04 AM
    Edited by Tequilla Butler Jun 07, 2021 04:02 PM
    **Disregard.  I found the issue****

    My Transform data using Power Query was working fine, then I went in and added a few more changes to the query.  When I click on edit query I can see the data and the step runs successfully, but instead of populating the body/value in the output it says 'Click to download'.





    When I click 'Click to download' 
    {"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Accept-Encoding","Strict-Transport-Security":"max-age=31536000; includeSubDomains","x-content-type-options":"nosniff","Content-Security-Policy":"default-src 'self'; child-src 'none'; manifest-src 'none'; media-src 'none'; object-src 'none'; worker-src 'none'; connect-src https:; img-src 'self' https://p.sfx.ms data:; style-src 'self' 'unsafe-inline'; frame-src *; frame-ancestors 'self' https://adf.azure.com https://ms-adf.azure.com https://*.ci.ai.dynamics.com https://*.api.ci.ai.dynamics.com https://msit.powerbi.com https://app.powerbi.com https://www.powerbi.com https://admin.powerplatform.microsoft.com https://dataintegrator.trafficmanager.net https://admin.powerapps.com https://admin.flow.microsoft.com https://*.admin.powerapps.com https://*.admin.flow.microsoft.com https://*.businessplatform.microsoft.com https://admin.microsoft.com https://us.flow.microsoft.com https://*.crm.dynamics.com https://*.iom.d365.dynamics.com https://teams.microsoft.com https://teams.powerbi.com https://web.powerapps.com https://*.web.powerapps.com https://make.preprod.powerapps.com https://make.preview.powerapps.com https://make.powerapps.com https://scv.dynamics.com https://scv.azureedge.net https://web.azuresynapse.net https://ms.web.azuresynapse.net; font-src 'self' https://static2.sharepointonline.com https://spoprod-a.akamaihd.net;","x-ms-result-type":"Exception","X-Rate-Limit-Limit":"30s","X-Rate-Limit-Remaining":"998","X-Rate-Limit-Reset":"2021-06-07T13:41:12.9975380Z","x-ms-connection-gateway-object-id":"202dc587-788a-4177-a960-453d962dc83f","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"no-cache","Date":"Mon, 07 Jun 2021 13:40:55 GMT","Content-Type":"application/json; charset=utf-8","Content-Length":"119"},"body":{"resultType":"Exception","message":"We couldn't convert to Number.","errors":[]}}


    ------------------------------
    TButler
    ------------------------------