DAX – XLCubed Blog ../../../ XLCubed Blog Tue, 09 Feb 2021 09:57:33 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png DAX – XLCubed Blog ../../../ 32 32 Faster Excel Queries For Power BI & Azure Analysis Services ../../../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/ ../../../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/#respond Tue, 09 Feb 2021 09:57:30 +0000 https://blog.xlcubed.com/?p=6286 If you have slow queries when reporting table format data in Excel from PowerBI.com, Azure Analysis Services or Tabular SSAS, this could be just the performance boost you need. Excel Pivot Tables query Power BI and Analysis Services using MDX, and sometimes the MDX they generate is not ideal. XLCubed Grids also query using MDX, […]

The post Faster Excel Queries For Power BI & Azure Analysis Services appeared first on XLCubed Blog.

]]> ../../../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/feed/ 0 DAX Performance tips– lessons from the field ../../../2016/06/dax-performance-tips-lessons-from-the-field/ ../../../2016/06/dax-performance-tips-lessons-from-the-field/#respond Fri, 10 Jun 2016 15:56:58 +0000 http://blog.xlcubed.com/?p=4239 XLCubed has supported a drag/drop interface for creating reports against Tabular Analysis Services since the first release of the new engine. It lets users easily create reports which run DAX queries on the cube, and we’ve often seen very good performance at customers when MDX against Tabular was a cause of long running reports. So […]

The post DAX Performance tips– lessons from the field appeared first on XLCubed Blog.

]]> ../../../2016/06/dax-performance-tips-lessons-from-the-field/feed/ 0 XLCubed V7 & SQL Server 2012 ../../../2012/03/xlcubed-v7-sql-server-2012/ ../../../2012/03/xlcubed-v7-sql-server-2012/#respond Mon, 19 Mar 2012 12:22:32 +0000 http://blog.xlcubed.com/?p=3270 SQL server 2012 has recently been released to manufacturing, and at XLCubed we’re well placed to take advantage of everything that is new in 2012. SQL 2012 delivers Business Intelligence under the ‘BISM’ umbrella (Business Intelligence Semantic Model). BISM comes in different flavours though: BISM Multi-dimensional (Latest version of Analysis Services as we know it) […]

The post XLCubed V7 & SQL Server 2012 appeared first on XLCubed Blog.

]]> ../../../2012/03/xlcubed-v7-sql-server-2012/feed/ 0