REST APIs with PAGINATION OR TOKENS with POWER BI Reports // Beginners Guide to Power BI in 2024

In this video were going to cover REST APIs and how you can utilise them to fetch data from online sources. Were covering the very basics, and how to deal with other scenarios like pagination and private APIs that require tokens.

🕓 TIMESTAMPS
0:00 - Intro
12:10 - Public REST APIs
07:40 - Private REST APIs
14:22 - Dealing with Pagination

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[smartymukherjee]

Such a great demo. Thank you so much! I have never done coding but I am gonna try to do 1 API call from Power BI from your video.... just to check if I can do it. I am so grateful that you are providing this knowledge for free. All your demos are very helpful....

[ninonninon]

That's what I've been looking for an entire week, thanks ! 🙏

[mayramedina]

Huge help my friend!!! Thank you very much!

[huangoliver]

Thanks.

In real-world scenarios, data ingestion often involves dealing with authentication mechanisms like OAuth 2.0, pagination, and handling large volumes of data. While Power Query is a powerful tool for data transformation and preparation, it is not be the most suitable choice for complex data ingestion tasks, especially at a large scale for Rest API.

Azure Data Factory is a powerful tool for data ingestion, it doesn't necessarily replace Power Query. In fact, you can leverage the strengths of both tools by using them in tandem

[azwarmzafar]

Thank you that is great video with lots of nice demonstrations.

[Zenoo]

Does someone know how to get the data from the repositories? For example excel files when he shows his repos at 14:00 ?