DATASMITH Blog

1

How to Create a Measure Group/Table in Power BI

When you have a very large dataset inside Power BI with many tables, it can become hard for a user to find measures or see an overview of all measures at once. Consider the below example, how can a new user know which tables contain measures without opening each one...

0

How to Kill SSAS Cube Stuck in Processing

In this post, I will show you how to kill an SSAS cube which is stuck in processing and cannot be stopped normally. In addition to that, you can also use this method for killing other SSAS related operations. In order to kill a processing cube we need the following...

1

Using Merge & Hashbytes for Slowly Changing Dimensions

In this post, we will have a look at how to perform slowly changing dimensions using MERGE & HASHBYTES. With this method, you can effectively perform INSERT, UPDATE & DELETE operations based on the differences found between two tables, namely, your source & target table. Note: You will be able...

0

A New Way to Deal with “String/Binary Data Truncated”

Anyone who has used SQL Server to insert data into a table has certainly come across the infamous error “String or binary data would be truncated” when data is too large to fit into the target data type. Let the hunt begin We all know if you are faced with...

0

UNION vs UNION ALL

In this post, we will have a look at the differences between UNION and UNION ALL operators using Heap and Clustered Tables. For this illustration, I will use the Adventure Works DW database. UNION – By default UNION does a distinct select on the valuesUNION ALL – Allows the selection...