Automating running PowerShell script which required Administrator elevation via SSIS
What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will run with elevated privileges. So in order to complete this we have to complete the following below but use a simple PowerShell script which will get all the FileNames from a Folder. Create a BAT…
Power Pivot and DAX in Power BI
Introduction: Something got me thinking the other day when I used the Google Analytics Connector and saw what looked like to me was a Power Pivot Model, as well as an image. I know in the current Power BI Designer as well as when you import an Excel file into Power BI on the web front end, you do not get to see these…
BI-NSIGHT | Mobile BI from Microsoft – SQL 2014 SP1 – Power BI (Google Analytics Connector)
This is a slightly different post from what I have been posting in the past, which has been completely technically focused! I have decided that I read up and look into so many things relating to the Microsoft BI eco system, that I should also share this with the readers and followers of my blog. Where I can give my…
SSAS – KPI’s – Example of creating a KPI
Based on the previous BLOG post <font color="#ff000, we are going to explain how to create a KPI Example · Using our Internet Sales cube, we want to create a KPI in order to see if the guys are meeting their new target which is a 10% increase from their current sales. · So we will create a new…
SSIS – Error Handling and Error emailing for Packages
What the steps below do is to handle error handling for your SSIS packages. And then within the error handling enable it so that you can email the exact error to email addresses so that they are notified when there is an error and what the error was. Example: · In our example we are going to be using…
Relocating to Australia – BI Job opportunities in Queensland
I thought I would let you guys know that I am about to relocate to Australia from South Africa. I have had an amazing time in South Africa, and learnt a whole lot whilst working at my past employer. So this is a plug at anyone who has any lead or potential BI work in Queensland, Australia. I would really…
SQL Server Analysis Services (SSAS) – Updating Project with Partition information
I am sure that this has happened to someone else before. You are making a change to your SSAS cube, within your SSAS cube you have created your initial partitions. But on your production server you have programmatically added additional partitions. Now by mistake or just not thinking you deploy your project, and when it prompts to overwrite your current…