video1.0<iframe src="https://www.loom.com/embed/83ef99454231464b91f90d6c7604432a" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/83ef99454231464b91f90d6c7604432a-00001.gif296.894In this video, I will show you how to use Power Query M to grab data with the Mcast API. I will start by generating an API key and then demonstrate how to set up the query in Excel using the ReadMe example. I will walk you through the steps of selecting the data source, accessing the Advanced Editor, and copying and pasting the code. Finally, I will make some adjustments to the code to customize the query. No action is required from you, this video is for informational purposes only.