Accessing Data via APIs in Power BI

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

2 hours
28 lessons
273 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: Creating Your Own JS Framework
intermediate
Total points: 48 XP 1 hours

Creating Your Own JS Framework

Understanding the architectural intricacies, design principles, and key techniques to build your own JavaScript framework.
Course Cover: Understanding the Evolution of Batman
beginner
Total points: 48 XP 1 hours

Understanding the Evolution of Batman

An insightful journey through the history and transformation of the iconic character, Batman.
Ahmed Khodir
Ahmed Khodir
See details
Course Cover: Data Analysis with PandasAI
intermediate
Total points: 186 XP 1 hours

Data Analysis with PandasAI

Unlock the power of data analysis and visualization with PandasAI, and transform raw data into actionable insights that drive decision-making and growth.
Tools
Python
Skills
Data Transformation
Data Analysis
Advanced Analytics
Data Visualization
Data Strategy
Business Analytics
Gaelim Holland
Gaelim Holland
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

FOR BUSINESS

Enterprise DNA

For Business

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

Learn More
power-bi-custom-visuals