---
title: "Discussion on \"Composite Models in PowerBI -- The solution to poor search performance in SSAS\" | Hashnode"
description: "Discussion on \"Composite Models in PowerBI -- The solution to poor search performance in SSAS\". With 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..."
url: "https://hashnode.com/posts/composite-models-in-powerbi-the-solution-to-poor-search-performance-in-ssas/634ddf050093580ccf2976d2"
---

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

Discussion

# [Composite Models in PowerBI -- The solution to poor search performance in SSAS](https://josefrichberg.com/composite-models-in-powerbi-the-solution-to-poor-search-performance-in-ssas?utm_source=hashnode&utm_medium=feed)

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

Oct 17, 2022 · 3 min read · josefrichberg.com  
Read the article

-   [#azure-analysis-services](https://hashnode.com/tag/azure-analysis-services)
-   [#composite-models](https://hashnode.com/tag/composite-models)
-   [#azure-sql-database](https://hashnode.com/tag/azure-sql-database)
-   [#powerbi](https://hashnode.com/tag/powerbi)
-   [#power-bi](https://hashnode.com/tag/power-bi)

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