Power BI - Call REST API

on YouTube ↗11m

" summary

Live demo shows calling a REST endpoint from Power BI Desktop using Python with pandas and requests and returns a JSON dataframe for Power Query. The flow sends three parameters (from, to, amount), transforms results by removing columns, filtering nulls, unpivot, transpose, rename and loads a table of current currency, conversion date, target currency, amount and converted value. Example converts 125 USD → 117 EUR. Notes: Power BI Service needs a gateway for Python refresh; Web connector is an alternative.

AI-written summary · about

" chapters (7)

1. 0:00Introduction and speaker info
2. 0:45Prerequisites for REST API call
3. 1:48Demo setup and Python script
4. 3:02Loading data in Power BI
5. 4:05Transforming data in Power Query
6. 6:51Visualizing API data in report
7. 8:17Q&A session and feedback

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 52mWhat's new on the Power BI RoadmapMohammad Ali, Rui Romano · SQLBits 2024
• 01h 13mDiscover, Acquire, and Transform Your Data with Power QueryMiguel Llopis · PASS Business Analytics Conference 2015
• 51mPower BI and Big TablesMarkus Ehrenmueller-Jensen · SQLBits 2024
• 54mWhat's new in Power Query in Power BI, Fabric and Excel?Chris Webb · SQLBits 2024
• 01h 03mFeed Your Data! OData Data Feeds for PowerPivot UsersChris Webb · PASS Business Analytics Conference 2013
• 54mExtending PowerPivot into a Scalable Component for Enterprise BIAvi Perez · PASS Business Analytics Conference 2013
• 40mSelf-Service ETL: The PowerBI Data FlowsDennes Torres · Data Con LA 2020