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
Here's What You'll Get
With The Course
More than 2 hours of self-paced training videos
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
This Course Module is Tailored for:
Data Analysts
Reporting Managers
Excel Users
Excel users, data analysts, reporting managers
LEARN HOW TO
Utilize the key features 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
4. JIRA API
- 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
Your 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
On-Demand
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
For Business