video1.0<iframe src="https://www.loom.com/embed/113272339e424218b5dd5ccebd245c33" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/113272339e424218b5dd5ccebd245c33-bf6699be690ae573.gif803.414In this video, I walk you through our template file for connecting to the Operating Dynamics API using Power Query. I explain how to input your credentials, including your region and organization name, and how to set the start date for loading historical data to avoid errors from overloading the system. I also highlight the importance of adjusting privacy settings to ensure smooth data retrieval. Please make sure to follow the steps I outlined, especially regarding the date format and security settings, to successfully load your data. If you have any questions or encounter issues, feel free to reach out!