API + Postman + Python + XML = Power BI
Warren Dean
![Warren Dean]()
Warren Dean
Founder @ DataTale.com.au | MCT | Power BI Training & Consulting for Government
Sharing an example of pulling data from an API and getting it into Power BI. I am keen to hear from the community on a more streamlined approach to extract straight from Power BI.
After reading through API documentation we can use Postman to test the API. See the below screen shots of using a POST.
In Postman we can then take the API code in many different formats. Here we take it in the Python > Request
Copy into Python and save as an xml
Load the xml in Power BI.
The end result. We now have a report showing the amount of bookings compared to utilised.
Keen to know if anyone has an example of taking a postman script and inputting that straight into Power BI.
Thanks,
Warren
Co-founder & CEO CAMANDA Academy | Founder, CAMANDA Technologies
6 年Hi, thanks for this post but a little more clarification required... I have my python request and I have saved this in a notepad editor using .xml...However I cannot get my PowerBI to run the query/code inside editor; what do I do? it only returns the content of my xml in text or sometimes error... Kindly advise me. Thanks
Senior GIS Officer at Moorabool Shire Council
6 年Garry Pugh?here's what Warren has come up with for PoolCar....