A powerful .NET library for executing multiple types of queries against Tabular Models using Microsoft's ADOMD.NET client and XMLA (XML for Analysis) protocol. Execute DAX queries, DMV (Dynamic Management Views), MDX, and other Analysis Services queries seamlessly across Power BI, SQL Server Analysis Services (SSAS), and Microsoft Fabric.
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using TabuLynx.Core.Configuration;
using TabuLynx.Core.Interfaces;
using TabuLynx.Query.Executor;
var host = Host.CreateDefaultBuilder(args)
.ConfigureAppConfiguration(config =>
{
config.AddJsonFile("appsettings.json", optional: false, reloadOnChange: true);
})
.ConfigureServices((context, services) =>
{
services.Configure<TabuLynxOptions>(context.Configuration.GetSection("TabuLynx"));
services.AddAdomdQueryExecutorForLocalPowerBI();
})
.Build();
var queryExecutor = host.Services.GetRequiredService<IQueryExecutor>();
var result = await queryExecutor.ExecuteQueryAsync("EVALUATE ROW(\"Current Time\", NOW())");
Console.WriteLine(result);
ASP.NET Core Web Application:
using TabuLynx.Core.Configuration;
using TabuLynx.Core.Interfaces;
using TabuLynx.Query.Executor;
var builder = WebApplication.CreateBuilder(args);
// Configure TabuLynx options
builder.Services.Configure<TabuLynxOptions>(
builder.Configuration.GetSection("TabuLynx"));
// Register query executor for local Power BI
builder.Services.AddAdomdQueryExecutorForLocalPowerBI();
var app = builder.Build();
app.MapGet("/query", async (IQueryExecutor queryExecutor) =>
{
var result = await queryExecutor.ExecuteQueryAsync("EVALUATE ROW(\"Server Time\", NOW())");
return Results.Ok(result);
});
app.Run();
2. SQL Server Analysis Services (SSAS)
Connect to an on-premises or cloud-hosted SSAS server.
services.Configure<TabuLynxOptions>(configuration.GetSection("TabuLynx"));
services.AddAdomdQueryExecutorForSsasServer();
// Usage
var queryExecutor = serviceProvider.GetRequiredService<IQueryExecutor>();
var result = await queryExecutor.ExecuteQueryAsync("EVALUATE SUMMARIZE(Sales, Sales[ProductCategory])");
3. Microsoft Fabric / Power BI Premium
Connect to Microsoft Fabric workspaces or Power BI Premium using Azure AD authentication.
services.Configure<TabuLynxOptions>(configuration.GetSection("TabuLynx"));
services.AddAdomdQueryExecutorForFabric();
// Usage
var queryExecutor = serviceProvider.GetRequiredService<IQueryExecutor>();
var result = await queryExecutor.ExecuteQueryAsync("EVALUATE TOPN(10, Sales, Sales[Amount])");
📊 Supported Query Types
TabuLynx.Query.Executor supports multiple query languages through the XMLA protocol:
DAX Queries (Data Analysis Expressions)
Execute business logic and analytical queries:
// Simple DAX evaluation
var result = await queryExecutor.ExecuteQueryAsync("EVALUATE ROW(\"Current Time\", NOW())");
// Table evaluation with filters
var salesData = await queryExecutor.ExecuteQueryAsync(@"
EVALUATE
TOPN(100,
FILTER(Sales, Sales[Amount] > 1000),
Sales[Amount], DESC
)");
// Measures and calculations
var kpiResult = await queryExecutor.ExecuteQueryAsync(@"
EVALUATE
ROW(
""Total Sales"", SUM(Sales[Amount]),
""Average Sale"", AVERAGE(Sales[Amount]),
""Sales Count"", COUNTROWS(Sales)
)");
DMV Queries (Dynamic Management Views)
Extract metadata and system information:
// Get all tables in the model
var tablesResult = await queryExecutor.ExecuteQueryWithDictionaryResultsAsync(
"SELECT * FROM $SYSTEM.TMSCHEMA_TABLES");
// Get column information
var columnsResult = await queryExecutor.ExecuteQueryWithDictionaryResultsAsync(
"SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS WHERE TableID = 1");
// Get measure definitions
var measuresResult = await queryExecutor.ExecuteQueryWithDictionaryResultsAsync(
"SELECT Name, Expression, Description FROM $SYSTEM.TMSCHEMA_MEASURES");
// Get relationship information
var relationshipsResult = await queryExecutor.ExecuteQueryWithDictionaryResultsAsync(
"SELECT * FROM $SYSTEM.TMSCHEMA_RELATIONSHIPS");
foreach (var table in tablesResult)
{
Console.WriteLine($"Table: {table["Name"]} (ID: {table["ID"]})");
}
MDX Queries (Multidimensional Expressions)
For OLAP cube operations and multidimensional analysis:
// Basic MDX query (when connecting to multidimensional models)
var mdxResult = await queryExecutor.ExecuteQueryAsync(@"
SELECT
[Measures].[Sales Amount] ON COLUMNS,
[Product].[Category].MEMBERS ON ROWS
FROM [Adventure Works]");