How to GET data from an API using POWER QUERY in Power BI | Food Bank & Job Search

preview_player
Показать описание
In this video, I show how easy it is to get data from an API using power query in power BI, although this will work with power query in excel too, for an API that does not require a key, and an API that does require a key.

📁 Give Food API documentation - 

🔖c h a p t e r s 🔖

00:00 - Intro
00:38 - API - No Key - Give Food
02:17 - Load API (no key) into PBI
06:41 - Load API (with key) into PBI

🙌 Follow Misha

🙌 Follow Jussi Halme

  1. Dean Chereden
  2. api testing
  3. api tutorial for beginners
  4. excel
  5. excel power query
  6. learn power bi
Рекомендации по теме
How to get 0:05:09

How to get (extract) data from graph (image) | Image digitizer | OriginPro

How to Get 0:05:19

How to Get data from image ( graph, results etc) │ Digitize your image │Easiest way

How to get 0:01:00

How to get data from an API with Javascript

API Endpoints? Get 0:05:38

API Endpoints? Get data from the web easily with PYTHON

GET Data from 0:05:50

GET Data from API & Display in HTML with JavaScript Fetch API

Easy way to 0:13:56

Easy way to get data from Movies & TV Shows with IMDB API and RapidAPI

How to get 0:01:00

How to get data from an API in React

How To Get 0:07:20

How To Get Data Internationally (3 Ways)

6 Remote Data 0:12:17

6 Remote Data Entry Jobs They Don't Tell You About 2024

How to get 0:00:36

How to get UNLIMITED DATA on android!

Microsoft Power BI 0:04:01

Microsoft Power BI | How to get LIVE data from Website? | Tutorialspoint

Microsoft Power BI 0:02:38

Microsoft Power BI | How to get data from SQL server? | Tutorialspoint

You must know 0:07:08

You must know this excel trick : Get data from website to Excel File

Tutorial GetData Graph 0:09:01

Tutorial GetData Graph Digitizer

How to get 0:05:49

How to get data from AJAX Requests in Python

How to get 0:05:19

How to get data from html form in php | How to read form data in php

Extract data from 0:08:08

Extract data from graph using GetData Graph Digitizer

Get Data - 0:03:52

Get Data - A 'Get Lucky' Science Parody

How to get 0:08:21

How to get data from a REST API in Power BI for rookies

How to get 0:00:59

How to get data from the web to Excel the right way! #excel #exceltutorial #exceltips #exceltricks

5 Methods To 0:14:18

5 Methods To Get Data From Google Sheets with Excel VBA

How to Import 0:05:18

How to Import PDF into Excel (Get Data from PDF is Missing)

PHP: How to 0:19:22

PHP: How to Get Data from a Request | PHP get and post form methods

Excel: Get Data 0:02:04

Excel: Get Data From a File Stored in a SharePoint Folder

Комментарии
Автор

Check out Orchestra - this sounds like you'd want to build an E2E pipeline to feed Power BI rather than just query from an API off the cuff!

OrchestraDataPlatform
Автор

Hi thanks for the video but if i have pagination for my api i need to hit api in loop for 10 pages data in power bi???

NaviHaviWorld
Автор

How we can access api data into an excel having bearer token?

NS-tpvr
Автор

Hi what if my API is RPC and i should send a json to request data, not only the link . How can i do this?

rezianaduzha
Автор

This is great! I am trying to get the data with an API key. My API link opens in the browser, yet when I try to open the API link as you showed in Power BI it states "Details: "Access to the resource is forbidden." Is there a solution you can suggest?

whyt
Автор

How about the price when I use this solution in production?

NguyenPhuc-otch
Автор

its not that easy anymore, if you use powerBI dataflows, it will require a Gateway =(

dipereira