https://community.fabric.microsoft.com/t5/Developer/HTTP-POST-Request-passing-ApiKey-in-Power-Query/m-p/1525559#M26636 <P>I'm trying to build a report from a third party API as a datasource and it requires POST requests. The documention provided is limited and I'm running out of how tos/article from Google searching! I could use some help here if anyone has figured out a solution.<BR /><BR />Here's where I'm at thus far.. I've tried what feels like every variation in the syntax..<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_1-1606803645959.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407692i321D431C0D5F739E/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_1-1606803645959.png" alt="CalebGuthrie_1-1606803645959.png" /></span></P><P>&nbsp;</P><P>This is what I'm getting in return.. It's been anywhere from this to cannot convet text to binary.<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_0-1606803294749.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407690iA7373330A5669DFB/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_0-1606803294749.png" alt="CalebGuthrie_0-1606803294749.png" /></span><BR /><BR />When I run it in Postman it works perfect.. just not in Power Query.<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_2-1606803848983.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407696iDE13F64D3A70DA01/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_2-1606803848983.png" alt="CalebGuthrie_2-1606803848983.png" /></span></P><P>&nbsp;</P><P>Sample data that was provided...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_3-1606804017301.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407697iF012842A516FC8C0/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_3-1606804017301.png" alt="CalebGuthrie_3-1606804017301.png" /></span></P><P>&nbsp;</P><P><BR /><BR /></P><P>&nbsp;</P> Tue, 01 Dec 2020 06:28:32 GMT CalebGuthrie 2020-12-01T06:28:32Z https://community.fabric.microsoft.com/t5/Developer/HTTP-POST-Request-passing-ApiKey-in-Power-Query/m-p/1525559#M26636 <P>I'm trying to build a report from a third party API as a datasource and it requires POST requests. The documention provided is limited and I'm running out of how tos/article from Google searching! I could use some help here if anyone has figured out a solution.<BR /><BR />Here's where I'm at thus far.. I've tried what feels like every variation in the syntax..<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_1-1606803645959.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407692i321D431C0D5F739E/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_1-1606803645959.png" alt="CalebGuthrie_1-1606803645959.png" /></span></P><P>&nbsp;</P><P>This is what I'm getting in return.. It's been anywhere from this to cannot convet text to binary.<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_0-1606803294749.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407690iA7373330A5669DFB/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_0-1606803294749.png" alt="CalebGuthrie_0-1606803294749.png" /></span><BR /><BR />When I run it in Postman it works perfect.. just not in Power Query.<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_2-1606803848983.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407696iDE13F64D3A70DA01/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_2-1606803848983.png" alt="CalebGuthrie_2-1606803848983.png" /></span></P><P>&nbsp;</P><P>Sample data that was provided...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CalebGuthrie_3-1606804017301.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/407697iF012842A516FC8C0/image-size/medium?v=v2&amp;px=400" role="button" title="CalebGuthrie_3-1606804017301.png" alt="CalebGuthrie_3-1606804017301.png" /></span></P><P>&nbsp;</P><P><BR /><BR /></P><P>&nbsp;</P> Tue, 01 Dec 2020 06:28:32 GMT https://community.fabric.microsoft.com/t5/Developer/HTTP-POST-Request-passing-ApiKey-in-Power-Query/m-p/1525559#M26636 CalebGuthrie 2020-12-01T06:28:32Z