In the November release of Power Query the most exciting new feature was the ability to connect to SSAS. I blogged about it at the time, but having used it for a month or so now I thought it was worth ...

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

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

This project demonstrates the development of an ETL (Extract, Transform, Load) pipeline for a banking system using SQL Server Integration Services (SSIS). It extracts data from multiple banking ...

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

See how you can get real-time interactive visualizations of customer data, as Microsoft Corporate Vice President James Phillips demonstrates exciting new capabilities available with Power BI and ...

SQL Server 2019 preview combines SQL Server and Apache Spark to create a unified data platform Today at Ignite, Microsoft announced the preview of SQL Server 2019. For 25 years, SQL Server has helped ...