Learn about new features and improvements in the most recent versions of SQL Server Analysis Services (SSAS). This version introduces Horizontal Fusion, a query execution plan optimization aimed at ...

When using SQL Server Profiler, keep in mind: Only database events are available for a Power BI Premium workspace. Server events are not available. Trace definitions are stored with the Analysis ...

A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...

Understanding the power of data analytics can transform your business, but to truly harness this power, you need the right tools. SQL Server Analysis Services (SSAS) is one such tool that can ...

Build enterprise-ready analytic solutions to deliver meaningful insights using familiar data visualization tools, such as Power BI and Excel. Create a single version of the truth across different data ...

In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful. In this post I’ll show you how you can use ...

“The June 2017 version of Power BI Report Server gave users the ability to create and publish Power BI reports on-premises by connecting to SQL Server Analysis Services data sources,” Finlan's ...

SQL Server Analysis Services, one of the key features of Microsoft’s relational database enterprise offering, is going to the cloud. The company announced Tuesday that it’s launching the ...

SQL Server Business Intelligence (BI) refers to a collection of Business Intelligence tools and technologies offered by Microsoft for data analysis and reporting. It is designed to help organizations ...