BI-NSIGHT – Power BI Designer Refresh – SQL Plugin for Excel – SQL Server 2016 In Memory Tables – Azure SQL Data Warehouse – Office 2016 Update – Power BI Content Pack (UserVoice)
Another week has gone by, so let’s get into what is currently out there and happening in the BI world. Power BI Designer Refresh I do know that this came out last week, but I still wanted to comment on this. Once again this is something that customers and myself have been waiting to be implemented and asked for on…
BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack
Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates. If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can…
BI-NSIGHT – Azure Analytics Services – Power BI Dynamics AX Connector – Auto refreshing of Excel Files in Power BI – Excel 2016 Updates
Once again this past week Microsoft as released even more products. So let’s get started. Azure Analytics Services On 29 April at the annual Microsoft Build conference they announced new services on the Azure platform. I really think that Microsoft is doing a great job of having an entire cloud platform available for customers. Due to the digital age and…
SQL Server 2014 Observations
Today’s post is not going to be about explaining something but more along the lines of my experience on SQL Server 2014. When I heard about all the new features in SQL Server 2014, the In Memory Tables, new cardinality estimator, new changes to how TempDB works, SSIS and Delayed Durability, I was excited to see how I could use…
SSIS – Creating new Partitions in SQL Server Analysis Services (SSAS) with XMLA and Analysis Services DDL
What I wanted to do is to create a process in SSIS that did not use code to create new SSAS Partitions using XMLA. NOTE: This is quite a long blog post, but it has all the details from start to finish to get this completed. Example: · We will be using the AdventureWorks2012DW data warehouse and Cube….
SSIS (SQL Server Integration Services) – Using the Lookup Transformation and cache and how to handle NULL Values
I had a situation where I was using the Lookup transformation and then loading this into the SSIS Cache, but I wanted all rows to be inserted using the SSIS Cache, even if there was a NULL Value. Below explains how I overcame this. Example: · In our Source data we have Products, but they might not be in…
SSAS (SQL Server Analysis Services) – Securing Measures in Measure Group for specific Roles
What I had to do today for the first time is to only show specific measures in the measure group for particular Roles (Users or AD Groups) · The reason that this was required is because we had sensitive information that was not for everyone’s eyes. NOTE: From my recent review and read through from the following book, http://www.packtpub.com/expert-cube-development-with-ssas-multidimensional-models/book…
SSIS – Running single SSIS packages in Parallel to get faster performance for multiple data loads
What we are going to show you below, is that by using ONE SSIS package, we can re-use this one SSIS package multiple times to get data from multiple sources, possibly from different databases hosted in different locations around the world. So in effect we are loading our data from one SSIS package in parallel. NOTE: By completing the…
SSIS – Getting Partition Names for the past 12 months
I had a situation where I was using a conditional split, so that when data was coming in from my source tables it would dynamically go into the correct partitioned table. Below is the script that I used, as well as for reference the conditional split — ================================================================================================================== — What we are doing here is to create a…
SSAS – Configuring the Slice Partition in your cube.
After recently going through an online video, I realized that I had not set the Slice option on the partition on a larger cube that I had. And by putting in the slice details this would then enable me to get faster queries when people were accessing the data. Below are the steps that I did in order to…