Following on from my last post covering DirectQuery in Power BI, I thought it might be interesting to take a look at the way MDX queries are supported in SSAS Tabular 2016 CTP3 DirectQuery mode. There ...

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data ...

Microsoft complements its relational database engine, SQL Server, with several add-on services that manage different aspects of enterprise business intelligence and information processing such as data ...

Extended Event Session to track all SQL Server Login events saved to .XEL Files ETL Process to move, load, clean and aggregate the XEL trace files from remote SQL servers into a central SQL database A ...

At Microsoft Build 2025, we announced the public preview of SQL Server 2025. Built on a foundation of best-in-class security, performance, and availability, SQL Server 2025 empowers customers to ...

Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of ...

This article describes a Microsoft SQL Server Analysis Services (SSAS) crash error that occurs when disk space is exhausted on the system hosting the SSAS instance ...