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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DoShawhan
New Member

Get Fedex Status from Query

Hello,

 

I am importing data into Power Bi using Odata. One column of the data is Fedex Tracking Numbers. I would like to append a column for delivery status to the query. I am trying to figure out how to get the data from Fedex, but I am struggling to find a way.

 

Any help is appreciated.

1 REPLY 1
Anonymous
Not applicable

  1. Get an API key from FedEx: First, you need to get an API key from FedEx to access their web services API. You can do this by registering for an account on the FedEx Developer Resource Center website and then following the steps to get an API key.

  2. Connect to the FedEx web services API in Power BI: In Power BI, you can use the "Web" data source to connect to the FedEx web services API. Enter the URL for the API and your API key in the "Basic" authentication mode.

  3. Query the tracking information: Once you are connected to the FedEx API, you can use the "Invoke Custom Function" feature in Power BI to call the "track" method of the API and retrieve tracking information for your FedEx packages. You will need to pass in the tracking number as a parameter to the function.

  4. Append the delivery status column to your query: After you have retrieved the tracking information for your packages, you can append a column to your original data query that displays the delivery status for each tracking number. You can use Power BI's "Add Column" feature to create a new column based on the tracking information you retrieved from the FedEx API.

Keep in mind that using the FedEx web services API may require some technical knowledge, so you may want to consult with a developer or IT professional if you are not familiar with the process.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.