SSAS Tabular Fact Table Tasks This post follows up on the SSAS Tabular 2017 partitioning post and lightly touches on two new features in SSAS
Tag: SSAS
SSAS Tabular 2017 Partitions
SSAS Tabular 2017 Partitions Incremental data refresh is not yet available to support large Power BI datasets. It’s on the Power BI Premium Roadmap, but,
New York and Boston Event Slides
Hi All – My presentation slides from the Power BI World Tour event in New York and the Boston SQL Saturday are available here: Power
SSAS Tabular vs Multidimensional Feature Matrix
One of the main themes from my SQL Saturday presentation in December was the ongoing enhancements to SSAS Tabular and how this impacts the decision
Deep Dive into Data Modeling using Power BI and SSAS
The presentation below from Kasper de Jonge, Senior Program Manager at Microsoft, was streamed earlier today and covers several core data modeling topics including: Bi-Directional Cross-filtering
Dynamic Dates via DAX
Dynamic DAX Date Queries The following zip file contains two DAX queries that dynamically calculate 23 date dimension values. Both queries produce the same result set but