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·150 readsPowerBI
Sumit Mondalsumit007.hashnode.dev·Dec 13, 2023The Power of Azure Analysis Services: A Creative Dive into Data InsightsIntroduction: In the ever-evolving landscape of data analytics, Azure Analysis Services emerges as a beacon of innovation, empowering organizations to glean meaningful insights from their vast reservoirs of data. As businesses strive to stay ahead in...DiscussAzure - TheoryAzure
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·332 readsKQL
Josef Richbergjosefrichberg.com·Oct 17, 2022Composite Models in PowerBI -- The solution to poor search performance in SSASWith the release of composite models in PowerBI, I’ve been able to solve a long-standing issue with SQL Server Analysis Services: text search performance. In this article I am going to use our Azure Hyperscale instance (but any Microsoft SQL Server i...Discuss·61 readsAzure Analysis Services
