BI-NSIGHT – Excel 2016 – Power BI Updates (Including new Data Sources) – Azure SQL Data Warehouse
So after last week, and the annual Microsoft Ignite conference, there was a whole stack of product announcements and updates. This was really great to see, and it once again amazes me how quickly Microsoft is able to get this to market. And being a Microsoft BI enthusiast, it excites me. I mean who does not like to play with…
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…
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…
Book review – Chris Webb – Power Query for Power BI and Excel
It has been a while since my last blog post due to relocating overseas. It has been quite busy and a lot of new things to learn but worth all the effort. When I saw the opportunity to review the book I jumped at it for multiple reasons. The first is that whilst I had dabbled with Power Query, I…
Excel–Power Query–Automating SSIS job duration report
Following on from our query to get our SSIS Job duration information, I decided to start using Power Query and see if I could use it to facilitate the automation of my reporting requirements. Detailed below is how and what I archived. Example · We are going to use our SSISDB to see if there have been any changes in…