{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/c5d649e41ce448b2b62d47b5cef95c4a\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/c5d649e41ce448b2b62d47b5cef95c4a-cf57dd754c08b5ed.jpg","duration":208.864,"title":"Power Query Custom Query Guide","description":"I walked through how to use the Power Query custom query box to customize and run queries, like changing the limit to 100 for running processes. For now, we will have a Confluence page in our documentation with pre tested queries and explanations you can copy and paste. I also demonstrated a custom query to check what Python libraries are installed on a host, and in one case the machine had no Python while the other returned a list of packages. This was to conclude the custom query process for Power Query."}