SSAS Tabular Live Power BI Connection

Posted by on Jul 27, 2015 in Power BI, SSAS | 4 Comments

When Power BI 2.0 released as General Availability I’ve published a post that highlights all new features in this product. One of the features was SSAS Tabular Live Power BI Connection. In this post I want to explore more what the Live connection means and what are advantages of this type of connection. Power BI ...

Read More

Format String Issue of SSAS Measures in Excel Front-End

Posted by on Dec 10, 2013 in SSAS | No Comments

Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount ...

Read More

Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling

Posted by on Mar 14, 2013 in Presentations, SSAS | No Comments

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at 2nd day of conference. here you can find presentation file of my speaking session about SQL Server Analysis Services Tabular Modelling Title:  SQL Server Analysis Services Tabular Modelling Description:  SQL Server 2012 provided another method for modelling BI presentation named SSAS Tabular Modelling. ...

Read More

SSAS Tabular – Microsoft Technical Articles

Posted by on Feb 27, 2013 in SSAS | No Comments

Yesterday in New Zealand Business Intelligence users group, attendees asked some questions that encouraged me to provide some links to Microsoft Articles written on SSAS Tabular. Here you can read more about these articles; Using DirectQuery in the Tabular BI Semantic Model Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services ...

Read More

SSAS Dimension Processing: Be Careful about Case Sensitivity

Posted by on Oct 26, 2012 in SSAS | No Comments

Hi folks, Yesterday I faced a situation in one of SSAS cubes, which dimension processing was failed because it found two different members with different attribute values, like Auckland and auckland ! I found out that reason of this problem is SSAS dimension will inherits its collation from underlying database and if you don’t change ...

Read More