Connect to API OAuth using PBI Data Flows

[mohammed_essam]

Hello,

I've an API secured with OAuth, how can I pull data from using PBI data flow. kindly find below an example of parameters I am using to connect to this API services

URL = 'https://sample.com/ws/schema/query/student_list'

Headers = @{ 'Authorization' = "Bearer $token" }

Method = POST

ContentType = 'application/json'

So does PowerBI support API with method Post for return JSON ? How Can I connect to this API service ?

[lbendlin · Accepted solution]

Yes, Web.Contents() with a data payload in the Content section switches from GET to POST.

Web.Contents - PowerQuery M | Microsoft Docs