Forum Discussion

Ryder's avatar
Ryder
Frequent Visitor
6 years ago

Converting Postman Request into PowerBI

Hey all,    I'm new to PBI and am attemping to migrate a functioning post request from postman to PBI. I can generate the code in a variety of languages from postman and am wondering what's the ea...
Need Help
Ryder's avatar
Ryder
Frequent Visitor
6 years ago

Getting this error now:

 

DataSource.Error: Web.Contents failed to get contents from 'http://api.ongage.net/' (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath=http://api.ongage.net/
Url=http://api.ongage.net/

 

I should mention this is a POST request which from what i'm seeing may have an affect on the syntax? 

 

Thanks for the help guys.

tonmcg's avatar
tonmcg
Resolver II
6 years ago

Do you have Fiddler? If so, capture the traffic from both the Postman request and the Power BI request. I don't have enough information, including what parameters you're passing, to be able to diagnose.

 

If you compare the headers each of the requests, you will be able narrow down the issue.

 

Here's a blog post from Chris Webb on using Fiddler with Power Query to help get you started.

  • Ryder's avatar
    Ryder
    Frequent Visitor
    6 years ago

    Here's a screen capture of the 400 pbi request vs the 200 postman request:

     

    I'm not entirely sure which one of the postman request to focus in on. 

    Thank you for the assistance!

    • tonmcg's avatar
      tonmcg
      Resolver II
      6 years ago

      Requests number 78 (the one in red) and 127 are the ones to focus on. 78 came from Power BI. 127 comes from Postman.

       

      All the other requests are from different applications running on your computer. Ignore those.

       

      Also, try using "https" instead of "http" in your requests.