Add or Edit Columns When Importing Data from Analysis Services into Power BI

If you use SQL Server Analysis Services as a data source for Power BI, you have two types of connection; Live Connection or Import Data. If you use Import Data, you can select columns and measures to be imported into Power BI. However, what if you want to add more columns to it, or edit Read more about Add or Edit Columns When Importing Data from Analysis Services into Power BI[…]

What is the Direction of Relationship in Power BI?

Relationships in Power BI are a bit different from other database management systems. In most of the systems, you just have a relationship and there is no “Direction” for it. In Power BI, however, there is a direction for the relationship. The direction of a relationship plays a critical role in the way that filtering Read more about What is the Direction of Relationship in Power BI?[…]

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[…]

A Glance At My Speaking Life (In a Year)

This year was an active year in my speaking life, In almost a year I’ve done below speakings: One SQL Rally Session (Denmark, Nordic) One Microsoft Ignite (New Zealand) Five SQL Saturdays (Austria, USA, New Zealand, Australia) Bunch of User Group and Codecamp speakings I started my peaking life with talking about MS data mining Read more about A Glance At My Speaking Life (In a Year)[…]

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.

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 6: Data Mining

dmm

Data Scientist is a hot job nowadays in the market and there are lots of demand for it. Data Science origins from the BI field and sits under umbrella of Business Intelligence, because the data science and data mining helps decision makers in their decision making process. To have an idea about how data mining can solve real world issues, think about loyalty program of the super market that you usually use close to  your home. Loyalty program simply analyze your purchase history and based on that it comes up with some suggestion and prediction about your next purchases and will promote that through your cell phone text messages or email or even flyers directly addressed to your home address.

[…]

PASS Summit 2014: Speaking about Deeper Data Insight and Prediction with Data Mining

Thanks you all attendees of my PASS Summit 2014 session on Deeper Data Insight and Prediction with Data Mining. It was a pleasure to have an overloaded room full of audience. and I apologize in advance if overload caused inconvenience for you through the session, especially for those of you who followed my session standing Read more about PASS Summit 2014: Speaking about Deeper Data Insight and Prediction with Data Mining[…]

Presentation Materials: TechDays Hong Kong 2014, Deeper Data Insight and Prediction with Data Mining

Thanks to all attendees of my session in TechDays 2014 Hong Kong about Deeper Data Insight and Prediction with Data Mining. Here is session Title, Description, and presentation file; Title: Deeper Data Insight and Prediction with Data Mining Description: Data Mining is the art of data analysis, finding data models, and predicting future behaviour based Read more about Presentation Materials: TechDays Hong Kong 2014, Deeper Data Insight and Prediction with Data Mining[…]

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[…]