How to get data from a REST API in Power BI for rookies
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- 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.
Chuck norris API: api.chucknorri...
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
************
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:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Love from India 🇮🇳 , you helped me to upgrade my job
This video has bridged a huge logic gap for me, thank you so much!
😃
lol Chuck Norris taught Ruth Power BI. 👍👍
Knowledge comes always from the most unexpected sources 😂😂
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!
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.
Please do a video on how to connect to jira
This would have been the last channel I would have expected to see a dirty chuck Norris joke on!
Oh no! The masking didn’t work?
I will hit Chuck Norris data creator one day for sure 🤣
exactly what i was looking for...thank you so much
Perfect!
Great content !
Awesome Ruth as always!
Great! Thanks Ruth!!
hello, how do you add "Convert" to the menues to see the json content, at 6:13-6:14? Thank you!
Yeah it’s not shown in the video, but she clicked on “source” under “applied steps” in power query editor
Love your channel❤️
Thanks 😊
Have one problem when commit on powerbi service.
The system not connect from variable connection source.
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
M query parameters, but they don’t work with an api only in direct query. Maybe if you do dataflow first?
@gulherme Pereira Have you somehow made such app in Power BI? If yes, can you give me some advice, how to made it? I try to made it using python, but it only work for definied visuals :(
Thanks a lot from colombia
Chuck and myself thank you as well :)
@@CurbalEN jajajaja
😂
Hi Ruth, does PBI support materialized views?
I am using different API but that API returns 50 rows per ID... How to do pagination on that? List. Generate returns empty list
Can we change datasource from azure storage to API?
Hello, what about getting data from an REST API with authentication?
Well, there are around 1M different ways to authenticate so it needs to be managed case by case. Bummer…
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: The underlying connection was closed: An unexpected error occurred on a send.. "API URL" . . The exception was raised by the IDbCommand interface. Table: "Table Name"
Never seen that error before, I am afraid 😳
@@CurbalEN Thanks for the response. Facing this weird issue for past 1 week. Will update if got something.
Yes please, you can report in also in issues.powerbi.com if it is something that happened suddenly
Would like to see api calls with differentiere parameters, username, password etc…
This is a tutorial to get started only :)
Great!! Thanks Ruth!!
🥳