Power Automate Exchange

**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
------------------------------

Hello
I am facing similar issue. What was your approach to solve this issue

Thanks

------------------------------
Ash Shah
------------------------------

Original Message:
Sent: Jun 07, 2021 10:03 AM
From: Tequilla Butler
Subject: Power Query output not showing body/value (click to download instead)

**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
------------------------------