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

Do you want to get data from an REST API, but are not sure how to do it? Well, Chuck Norris and myself will walk you through the steps.

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10

Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[myvotemypower]

Love from India 🇮🇳, you helped me to upgrade my job

[dashathomas]

This video has bridged a huge logic gap for me, thank you so much!

[spen]

lol Chuck Norris taught Ruth Power BI. 👍👍

[williamhoover]

Hi Ruth, I always enjoy your videos! I'm wrestling with getting data from the Harvest time tracker. This is an account where we have a login, so it's not a straightforward process (although they do have a rest API). I'm clueless about API's and wondered if you had any videos where you deal with security, tokens, etc? Thanks!

[shrirajdeshpande]

I will hit Chuck Norris data creator one day for sure 🤣

[PeterKontogeorgis]

This would have been the last channel I would have expected to see a dirty chuck Norris joke on!

[pritichaudhari]

Hello,

Would you please make a video on, how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

Thank you.

[aswinkumar]

Please do a video on how to connect to jira

[warlockalpha]

Have one problem when commit on powerbi service.
The system not connect from variable connection source.

[coolrakesh]

exactly what i was looking for...thank you so much

[saadhafeez]

I am using different API but that API returns 50 rows per ID... How to do pagination on that? List. Generate returns empty list

[liviamoen]

hello, how do you add "Convert" to the menues to see the json content, at 6:13-6:14? Thank you!

[swapnab]

Can we change datasource from azure storage to API?

[gulhermepereira]

Hi, Ruth, great content as always!
Do you know a way to get a user input (by a slicer) and then call the API based on that value?
Exe: User select a radius length in a slicer than you call the API to get the area on the fly

[swapnab]

Hi Ruth, does PBI support materialized views?

[gentapapakroni]

Hello, what about getting data from an REST API with authentication?

[kmhadk]

Would like to see api calls with differentiere parameters, username, password etc…

[tamilgenysisgaming]

Hi, i am able to establish connection with API and able to refresh in power bi service also without any issue. BUT, when i publish my report to premium workspace and tried to refresh its throwing me this error => DataSource.Error: <pii>The underlying connection was closed: An unexpected error occurred on a send.</pii>. <pii> "API URL" </pii>. . The exception was raised by the IDbCommand interface. Table: "Table Name"