Hi everyone,
I'm trying to connect Power Automate against a SQL-Server. The gateway is working fine with triggers like 'when an item is created' and tasks like 'get rows' but it is not working well with power query.
I have access to all tables within the power query editor, but when I run my flow, this is the output:
{"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://portal.azure.com https://rc.portal.azure.com https://ms.portal.azure.com https://*.consent.dynamics.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://emea.flow.microsoft.com https://*.crm4.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.azureedge.net https://scv-int.azureedge.net https://sci.preview.dynamics.com https://sci.dynamics.com 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-11-11T10:07:31.8707586Z","x-ms-connection-gateway-object-id":"a9df27ba-4577-46db-966e-1a426eb91509","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"no-cache","Date":"Thu, 11 Nov 2021 10:07:25 GMT","Content-Type":"application/json; charset=utf-8","Content-Length":"115"},"body":{"resultType":"Exception","message":"One or more errors occurred.","details":[],"errors":[]}}
Any help would be greatly appreciated.
Rgds,
Mat
