The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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.
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.
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.