BI-NSIGHT – Power BI GA (24 July 2015) / Updates – SQL Server 2016 CTP2.2 (SSRS Treemap & Sunburst Charts)
This week has been another amazing and interesting week with regards to Power BI. So here are is the latest information that I could get my hands on! Power BI – GA (General Availability) This week finally Power BI will go into General Availability. Which has been a long time coming and something that I have been looking forward to…
BI-NSIGHT – Multiple Power BI Announcements – Cortana Analytics – Particle and Microsoft – Azure Data Catalog – Power Query Update
So the past week has been filled with a whole host of announcements, particularly in the Power BI space, but as well as with Microsoft’s cloud based solutions. A lot of the information that I have found due to the current World Partner Conference! So as we do every week, let’s get into the amazing details. There is quite a…
BI-NSIGHT – Power BI for Android Devices – Power BI Designer vs Excel – Power BI Refresh for On-Premise – Power BI Refresh from OneDrive – Power BI Interface Updates
Whilst I thought that this week might be a bit on the quiet side, I think that my previous suspicion is correct, and the wonderful people from Microsoft like to send out updates on a Wednesday. Power BI for Android Devices I was just browsing through twitter and I came across a tweet and clicked on the link, not entirely…
BI-NSIGHT – Power BI Designer Update – Power BI Twilio Connector – Excel 2016 Visualisations – Azure Data Lake
Fortunately this week, the Microsoft machine was a little quieter, but still as expected new updated in the Power BI Space. Power BI Designer Update I have read quite a few blog posts, downloaded and viewed the Power BI Designer update. And I have to say they are some welcome changes. In my mind I see that over time,…
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…
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…
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…
SharePoint 2013 – Creating a data source to an SQL Server Analysis Services (SSAS) OLAP Cube
Below are the details when using SharePoint 2013 when you want to collect to an SQL Server Analysis Services (SSAS) OLAP cube, instead of only being able to use the SSAS Tabular. Example: · In our example we are going to connect to our Adventure Works DW 2012 SSAS 1. Go into your SharePoint 2013 website and then…
Power View – Using MDX, SSAS Tabular and Power View to display potential issues based on past trends in data
What I am going to explain below is using the above MDX, SSAS Tabular and Power View to display potential issues based on past trends within our data. For our example we are going to using the example of SCOM data. Within our example we are looking for systems where the available memory has dropped more than 50% of…