Platform Access

Accessing Data via APIs in Power BI

Learn different types of authentication methods and connect APIs to data sources using Power BI, a perfect tool for retrieving data

Enroll Now
Accessing Data via APIs in Power BI

Here's What You'll Get

With The Course

More than 2 hours of self-paced training videos

Accessing Data via APIs in Power BI

Discover the different type of authentication methods and tools using APIs

  • Utilize a multitude of data available in the universe of applications and web services. The way to get them is through APIs.

  • 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.

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
Accessing Data via APIs in Power BI

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Excel users, data analysts, reporting managers


Utilize the key features Power BI

Accessing Data via APIs in Power BI
  • Tool for retrieving data using API
  • Expand the capabilities of Power BI
  • Develop APIs in Power BI
  • Connect APIs to data sources like methods, authentication and pagination.
  • Understand APIs in the Power BI

Course Curriculum

1. Introduction

  • Introduction

2. Chuck Norris

  • Our first API
  • Introduction to the cheat sheet
  • Working with a different endpoint
  • Query Parameters
  • Our first function
  • API list as a parameter

3. News API

  • Introduction to News API
  • Fixing the query code; creating a function for requesting news of different categories
  • Authentication methods: Headers, query parameters
  • Template files and Parameters


  • Getting our token
  • Base64 encoding
  • First exercise
  • First exercise - Solution
  • Pagination - Basic - list of pages
  • List.Generate
  • List.Generate Exercise Fibonacci
  • List.Generate Solution Fibonacci
  • List.Generate Pagination JIRA API

5. API Tools

  • Introduction
  • JSON Beautifier
  • Postman
  • HTTP Debugger

What our Students Say

Your Instructor

Enterprisedna - Oscar Martinez Valero Instructor

Oscar Martinez Valero

  • Oscar Martinez Valero is one of the world’s experts when it comes to using APIs in Power BI. He has done plenty of research and written extensively on this topic, as well as developed a number of custom Power BI connectors.
  • Many of you know him as a wildly creative Power BI expert developer who was a finalist in this year’s Microsoft Power BI Championship in Switzerland.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or For Business access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA For Business. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA


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

For Teams

Enterprise DNA

For Business

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