Accessing Data via APIs in Power BI

Expand Power BI's capabilities in accessing a wide range of data using APIs

schedule2 hours
play_circle24 videos
unfold_more28 exercises
trending_up273 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course

There is a multitude of data available in the universe of applications and web services. The way to get them is through APIs. However, there is a limitation to what we can do with the data that we get with APIs by themselves. We need a tool for retrieving this data, and the perfect tool to do that is with Power BI. However, this does not come easy. It is a tricky process that involves methods, authentication and pagination.

In this course by Oscar Martinez Valero, he will show us how to successfully use APIs to retrieve data in Power BI and expand the capabilities of Power BI while taking advantage of the data that is not available through traditional means.


What are needed to take the course

This is an intermediate course. A basic knowledge of Power Query is required.

Who is the course for

This course is for all analysts working with data from different sources while using Power BI.

Details of what you will learn during this course

  • Understand APIs  in the Power BI context
  • Connect APIs to data sources like Chuck Norris jokes, NewsAPI, JIRA, and bring it to Power BI
  • Transform data retrieved via Power BI with correct parameters to make the file usable
  • Learn the different types of authentication methods
  • Develop APIs in Power BI using different tools like JSON Beautifier & Editor, Postman, and HTTP Debugger

What you get with the course

More than 2 hours of self-paced training videos

What our

Students Say
Curriculum
1

Introduction


2

Resource


3

Chuck Norris


4

News API


5

JIRA API Prework


6

JIRA API


7

API Tools


8

Your Feedback


9

Certification


Your

Instructor
Empty image or helper icon

Oscar Martinez Valero

We are always looking for the best solution for you

Frequently Asked

Questions

Recommended

Courses
Course Cover: Artificial Neural Networks 101: Intro to Deep Learning
intermediate
Total points: 172 XP clock-blue 1 hours

Artificial Neural Networks 101: Intro to Deep Learning

Unraveling the Mystique: A Beginner's Dive into Neutral Networks.
Tools
Python
R
Skills
Data Transformation
Data Analysis
Advanced Analytics
Data Visualization
Data Modeling
Gaelim Holland
Gaelim Holland
See details
Course Cover: Introduction to Pyspark: Handling Big Data with Pandas Polars and Pyspark
beginner
Total points: 220 XP clock-blue 2 hours

Introduction to Pyspark: Handling Big Data with Pandas Polars and Pyspark

Uncover the secrets of efficient data processing using PySpark, Pandas, and Polars, and elevate your data analysis skills to new heights. Let's explore, transform, and analyze large datasets together, simplifying the complexities of big data management!
Tools
Python
SQL
Other Tools
Skills
Data Transformation
Data Analysis
Data Visualization
Gaelim Holland
Gaelim Holland
See details
Course Cover: Introduction to ChatGPT's Advanced Data Analysis (ADA)
beginner
Total points: 208 XP clock-blue 1 hours

Introduction to ChatGPT's Advanced Data Analysis (ADA)

Unlocking Advanced Insights with ChatGPT's Advanced Data Analysis (ADA)
Tools
Power BI
Python
Excel
SQL
Skills
Data Transformation
Data Analysis
Advanced Analytics
Data Visualization
Sam McKay
Sam McKay
See details

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More chevron_right

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More chevron_right
power-bi-custom-visuals