---
title: "Discussion on \"Pulling Azure Analysis Services logs from Azure Log Analytics into PowerBI using Kusto Query Language (KQL)\" | Hashnode"
description: "Discussion on \"Pulling 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..."
url: "https://hashnode.com/posts/pulling-azure-analysis-services-logs-from-azure-log-analytics-into-powerbi-using-kusto-query-language-kql/6465133b2aedfcbce533ce8f"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Pulling Azure Analysis Services logs from Azure Log Analytics into PowerBI using Kusto Query Language (KQL)](https://josefrichberg.com/pulling-azure-analysis-services-logs-from-azure-log-analytics-into-powerbi-using-kusto-query-language-kql?utm_source=hashnode&utm_medium=feed)

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...

May 17, 2023 · 2 min read · josefrichberg.com  
Read the article

-   [#kql](https://hashnode.com/tag/kql)
-   [#powerbi](https://hashnode.com/tag/powerbi)
-   [#azure-analysis-services](https://hashnode.com/tag/azure-analysis-services)
-   [#azure-log-analytics](https://hashnode.com/tag/azure-log-analytics)

## Written by

[Josef Richberg](https://hashnode.com/@josefrichberg)

@josefrichberg · Pennsylvania, US

  
[View profile](https://hashnode.com/@josefrichberg)

Principal Data Architect, Azure @ Penguin Random House

I've been working in and around SQL for over 3 decades. I am currently working on making our business intelligence systems self-driven by using an event-based architecture. This involves providing curated data in some of the largest SQL Azure Analysis Services cubes ever built (over 6 billion records in 1 table alone). I've developed several APIs leveraging a serverless Azure architecture to provide real-time data to various internal processes and projects. Currently working on Project Dormouse; Durable select messaging queue that enables polling processes to extract specific messages.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
