Josef Richbergjosefrichberg.com·Feb 6, 2024Extracting Azure Analysis Services Metrics from your Log Analytics workspace into PowerBIWe have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will enable you to pull all the user/query information necessary to manage these servers...Discuss·71 readsPowerBI
Sandeep PawarProfabric.guru·Aug 27, 2023Creating Shortcut To KQL Table In Fabric LakehouseShortcuts in Microsoft Fabric are one of the best features that allow you to point to any location on OneLake from any engine without moving the original data. It just magically makes it appear virtually via embedded references within OneLake. The of...Sandeep Pawar and 1 other are discussing this2 people are discussing thisDiscuss·500 readsKQL
Sandeep PawarProfabric.guru·Aug 25, 2023Building Insightful Analytical Solutions Using KQLMagicA few months ago, I wrote a blog post about querying a KQL database in Fabric notebooks using the Python Kusto SDK. Although it works perfectly, my friend Alex Powers reminded me that kqlmagic can also be used in notebooks for a more ad hoc experienc...Discuss·456 readsmicrosoftfabric
Rutger SmeetsProrutgersmeets.eu·Jul 16, 2023Kusto Detective Season 2 Case 5 - Blast into the pastIn case you're stuck, or if you're not participating in this season and just reading along to gain some KQL skills, I hope that you find use in these notes. SPOILERS AHEAD! Assignment and data We start the case by ingesting data into a table named ...Discuss·36 readsKQL
Sandeep PawarProfabric.guru·Jun 12, 2023Querying KQL Database in Fabric NotebookIn Azure Data Studio, you can install the KQL extension to connect to and query Azure Data Explorer clusters. This allows you to access the KQL database and query/plot right in the notebook. Microsoft Fabric notebook does not have such an extension n...Discuss·736 readsmicrosoftfabric
Josef Richbergjosefrichberg.com·May 17, 2023Pulling Azure Analysis Services logs from Azure Log Analytics into PowerBI using Kusto Query Language (KQL)We have very large Analysis Services(SSAS) cubes with billions of records and hundreds of users so we need to be able to monitor the performance of queries. 95% of this universe are users of reports built for them by knowledgeable report builders. Th...Discuss·232 readsKQL
Asherasherl.com·Mar 13, 2023Using MS Graph API, 365 Defender, Azure Functions and PowerBIHigh Level Plan The architecture will begin with the use of the MS Graph Security API to fetch alerts from MS 365 Defender. This will be triggered using an Azure Function, which will then store the response in a CSV file. The CSV file will be loaded ...Discuss·404 readsoffice365
Sven Bergendahlsvenbergendahl.com·Feb 7, 2023Troubleshooting Azure Application Gateway: A Collection of Useful KQL QueriesIntroduction Updated: 16/03/2023 The Azure Application Gateway is a highly scalable and managed web traffic load balancer that provides application-level routing, load balancing, and web application firewall services. However, despite its simplicity ...Discuss·584 readsKQL
Akhere Sonny-Egbeahieakhere.hashnode.dev·Dec 17, 2022Hunting Unsigned DLLs Using KQLUnsigned DLLs, or dynamic-link libraries, are executable files that contain code that can be used by multiple programs on a Windows system. While DLLs can be a useful and efficient way to share code between applications, they can also be a security r...Discuss·580 readsKQL
