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

Поділитися
Вставка
  • Опубліковано 20 жов 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

КОМЕНТАРІ • 40

  • @myvotemypower9788
    @myvotemypower9788 2 роки тому +5

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

  • @dashathomas9395
    @dashathomas9395 9 місяців тому +1

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

  • @spen2431
    @spen2431 2 роки тому +5

    lol Chuck Norris taught Ruth Power BI. 👍👍

    • @CurbalEN
      @CurbalEN  2 роки тому +1

      Knowledge comes always from the most unexpected sources 😂😂

  • @williamhoover830
    @williamhoover830 Рік тому +3

    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!

  • @liviamoen1962
    @liviamoen1962 Рік тому +1

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

  • @pritichaudhari7596
    @pritichaudhari7596 Рік тому +1

    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.

  • @aswinkumar5369
    @aswinkumar5369 2 роки тому +1

    Please do a video on how to connect to jira

  • @147coolrakesh
    @147coolrakesh 2 роки тому

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

  • @PeterKontogeorgis
    @PeterKontogeorgis 2 роки тому

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

    • @CurbalEN
      @CurbalEN  2 роки тому +2

      Oh no! The masking didn’t work?

  • @shrirajdeshpande8125
    @shrirajdeshpande8125 Рік тому

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

  • @warlockalpha
    @warlockalpha 2 роки тому

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

  • @swapnab4453
    @swapnab4453 2 роки тому

    Hi Ruth, does PBI support materialized views?

  • @saadhafeez9171
    @saadhafeez9171 2 роки тому

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

  • @swapnab4453
    @swapnab4453 2 роки тому

    Can we change datasource from azure storage to API?

  • @gulhermepereira249
    @gulhermepereira249 2 роки тому +1

    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

    • @CurbalEN
      @CurbalEN  2 роки тому

      M query parameters, but they don’t work with an api only in direct query. Maybe if you do dataflow first?

    • @krolfaust8184
      @krolfaust8184 2 роки тому

      @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 :(

  • @gabriellegall8278
    @gabriellegall8278 Рік тому

    Great content !

  • @abhishekstatus_7
    @abhishekstatus_7 2 роки тому

    Awesome Ruth as always!

  • @diegolozano2397
    @diegolozano2397 2 роки тому

    Thanks a lot from colombia

  • @myvotemypower9788
    @myvotemypower9788 2 роки тому

    Love your channel❤️

  • @DanielAndresMiranda
    @DanielAndresMiranda 2 роки тому

    Great!! Thanks Ruth!!

  • @gentapapakroni8262
    @gentapapakroni8262 2 роки тому

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

    • @CurbalEN
      @CurbalEN  2 роки тому

      Well, there are around 1M different ways to authenticate so it needs to be managed case by case. Bummer…

  • @tamilgenysisgaming9465
    @tamilgenysisgaming9465 2 роки тому

    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"

    • @CurbalEN
      @CurbalEN  2 роки тому +2

      Never seen that error before, I am afraid 😳

    • @tamilgenysisgaming9465
      @tamilgenysisgaming9465 2 роки тому

      @@CurbalEN Thanks for the response. Facing this weird issue for past 1 week. Will update if got something.

    • @CurbalEN
      @CurbalEN  2 роки тому

      Yes please, you can report in also in issues.powerbi.com if it is something that happened suddenly

  • @kmhadk
    @kmhadk 2 роки тому

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

    • @CurbalEN
      @CurbalEN  2 роки тому +1

      This is a tutorial to get started only :)

  • @wayneedmondson1065
    @wayneedmondson1065 2 роки тому

    Great! Thanks Ruth!!