Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
VFXPro
Advocate II
Advocate II

How can I insert an API Body when connecting to API as data source?

I'm trying to connect to UPS Quantum View API.  It works well via POST MAN but I'm not getting data from Power BI since it requires my ups login information in the body of the API call.

 

Body from PostMAN

VFXPro_1-1627327759232.png

 

Current connection to the API in Power BI, but missing the body from above.  How can I insert it and where do I paste it?  I don't understand the syntax required to insert the body into Power BI.  There are no clear instructions anywhere that I can find...  

VFXPro_0-1627327690495.png

Thanks for your guidance.  MS has to improve this process to truly make Power BI accessible for more people.

3 REPLIES 3
VFXPro
Advocate II
Advocate II

Hi Pat,

I had already look at those articles before coming to this forum and unfortunately, they don't provide much help.  Also, I'm not a developer.  I posted a screenshot to better show what is going on. I pasted the body I'm using from Postman into Power BI advanced editor and I'm not having any luck  Most likely a syntax/formatting problem.  I just don't know where to insert the text string highlited in yellow in the image below.  I'm baffled as to why MS doesn't make Power BI easier to connect to APIs since it's supposed to help "low code" or "citizen developers" to get to data soures.

 

Hopefully, some can tell where to move that text string or provide guidance on the syntax required. 

 

VFXPro_0-1627581523837.png

 

Hi  @VFXPro ,

 

Check a reference below which may help:

https://docs.microsoft.com/en-us/azure/data-factory/connector-rest

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

mahoneypat
Microsoft Employee
Microsoft Employee

Please see this articles for how to send a body with your POST requests.

Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant

Chris Webb's BI Blog: Web Services And POST Requests In Power Query Chris Webb's BI Blog (crossjoin....

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.