Connecting REST APIs to Power BI with Dominick Raimato

Hi Everyone - our next session has crept on me again!

It's tomorrow(!) and our presenter Dominick will take us through a really useful topic and skill of integrating Power BI with REST APIs

Please join us tomorrow, 4th March, at our usual 12:30pm ACDT (Adelaide time) for what promises to be an interesting session

thanks, Ben & Heidi

Description
Automated refreshes are critical to the success of many reporting solutions. Most developers prefer connecting to databases or data warehouses where they have control over the resource allocation and transformation of the data all before it reaches Power BI. But what happens when you do not have direct access to the database? What happens if the data is hosted by a 3rd party cloud platform? What if you ask for a way to get the data and they send you documentation on their APIs and say good luck?

If you have asked these questions, then this session is designed specifically for you. We will walk you through the basics of understanding API documentation and show you how to connect with the Web connector in Power BI. We will also cover some of the basic transformations you can perform to make your queries more efficient and highlight some of the blockers you might encounter. We will even build a function with an API and apply it to a dataset.

At the end of this session, you will feel comfortable using REST APIs as a data source and building connections using best practices.

Dominick Raimato
Power Platform Solutions Architect
Self-identified as a data nerd, Dominick Raimato has had a huge passion for identifying insights and building solutions. You never know what kind of data projects he might be working on such as tracking temperature and humidity trends in his house to building a database of property assessments to make sure his house is in line with other properties to avoid overpaying taxes. Passionate about people, Dominick strives to create solutions that not just help achieve business objectives, but also make people’s lives better. If he can help someone get home earlier to eat dinner with their family or eliminate time consuming tasks so they can focus on more important things, he is in his element.

Dominick currently lives in Bergen County, NJ where he can be found around the house working on projects or cooking in the kitchen. His specialty dishes include his homemade meat sauce in the winter and pulled pork bar-b-que on his smoker during the summer. He also ventures into New York City frequently to see his wife perform as a flutist with small ensembles, orchestras, and theaters.