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…
Automating refreshing of Power BI Reports and Dashboards with Excel Workbooks and Power Update
I recently tested to see if it was possible to upload an Excel Workbook to One Drive for Business, and then use this within Power BI. This was successful. Then I saw, and it appeared that if you used an Excel Workbook from One Drive for Business, that it would automatically refresh the file. Which I thought it might possibly…
BI-NSIGHT | Power Pivot & DAX in Power BI – SharePoint 2016 – Power BI AS Connector – Power BI Designer Preview Update – New Power BI Content Packs
In a week there have been a whole host of updates and changes within the Microsoft BI space. So let’s get to it. Power Pivot & DAX in Power BI This is related to my blog past that I created earlier this week (Power Pivot and DAX in Power BI). And it was amazing to see that later on in…
Microsoft Power BI Designer Now supports DAX Calculated Measures
Just a quick update, I was busy working on a Power BI presentation and thought let me just download the Microsoft Power BI Designer and see if it has been updated. And to my great surprise it has. It appears as though it was updated on 21 April 2015. I then went and installed the downloaded version of Microsoft Power…
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…
SSIS – Configuring SSIS Package to run job after data loading has completed
In our example below, we are going to be using a SharePoint 2013 Data Alert job which was created in SQL Server Agent, and then insert this into an existing SSIS Project. The reason for doing this, is so that every time our SSIS Project runs, as part of the process, it can then fire off a SQL Server Job….
Power Query – Adding Leading Zero to Number (EG: Month Number)
Below is an example if you have a requirement and you want to add a leading zero Example: You have a Month Number that starts with “1”, and you want it to start with “01” In your Power Query Window, click on Add Custom Column and then put in the following syntax Text.PadStart(Text.From([Month]),2,”0″) NOTE: In the above example, we have…
For SQL Server 2014 – Use the following link below to use an oData Source to get data from SharePoint List into your table
Below are the steps if you want to use SQL Server 2014 to get data from a SharePoint list into your database. The URL below explains how to download and install the OData Source for SQL Server 1. Click on the following link below a. http://www.microsoft.com/en-us/download/details.aspx?id=42295 2. Then once you load the page click on Download a. This will then…
SSRS – Microsoft sql server fitler table/matrix with 2nd row of data
What I wanted to do, was to create multiple table/matrix, but to have them separate. And then to have 5 of them in total. But I wanted to have the top 5. So I wanted the first one to be the top value, then top 2, top 3, top 4 and top 5. This is what the result looks like:…