Fun with DAX – A-Maze-ing DAX

Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to Read more about Fun with DAX – A-Maze-ing DAX[…]

Row Level Security with SSAS Tabular Live Connection in Power BI

You can define Row Level Security in Power BI itself, However sometimes you do use SQL Server Analysis Services Tabular as the source for Power BI through Live or DirectQuery connection. SSAS Tabular allows you to create same type of Row Level Security. So it would be much better to use Row Level Security defined Read more about Row Level Security with SSAS Tabular Live Connection in Power BI[…]

SSAS Tabular Live Power BI Connection

4

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 Designer (Previous version of Power BI Desktop) was supporting offline connection to SSAS. The new SSAS Live connection of Power BI only works with SSAS Tabular at the moment.

[…]

SSAS Processing Failure; OLE DB or ODBC error – 08001

Today I faced a new error type that I’d never seen before in my many years of experience with SSAS. It was one of the most weird errors that I’ve seen so far. let me explain that in a scenario; I had a SSAS multi-dimensional cube working and fully processing on the DEV server. then Read more about SSAS Processing Failure; OLE DB or ODBC error – 08001[…]

Format String Issue of SSAS Measures in Excel Front-End

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 about Format String Issue of SSAS Measures in Excel Front-End[…]

SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.

This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error. Reason: There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups. for example you might find some membership entries with GUID listed Read more about SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.[…]

Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling

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 about Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling[…]

SSAS Tabular – Microsoft Technical Articles

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 about SSAS Tabular – Microsoft Technical Articles[…]

SSAS Dimension Processing: Be Careful about Case Sensitivity

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 about SSAS Dimension Processing: Be Careful about Case Sensitivity[…]