BI-NSIGHT – Power BI (Mobile App Update, Waffle Chart Visual, Alpine Metrics Content Pack, KPI Indicator Visual Explained) – SQL Server 2016 (Hear from the Engineers, Virtual Lab, KPI Data Refresh) – Excel 2016 (New Functions, Power Query Update)
There has been a lot happening in the BI space over the past week. Loads of things to read about and review and see how this can be integrated and used. So without any further delay let’s get into the details. Power BI – Mobile App Update They have made some great improvements to the Mobile App, currently only for…
BI-NSIGHT – Power BI Desktop (Monthly & Service Update) – Excel 2016 (Add-In for Machine Learning) – Power BI (Sankey Visual, Power BI Community, Office365Mon Content Pack)
As this year begins to really wind down it is good to see that the Microsoft machine also appears to be having a break. I have no doubt that in 2016 it will be full steam ahead and back into the swing of things. And before I could finish this blog post I checked if there was any news and…
BI-NSIGHT – SQL Server 2016 (CTP 3.1, SSAS Tabular) – Power BI (Cortana, Mobile App, Enterprise Gateway, Bing Content Pack, API Updates, Sentiment Analysis) – Data Insights Summit – Power Apps
Once again this week there has been a lot of activity in the BI space. Which is great and is definitely keeping me on my toes! SQL Server 2016 – CTP 3.1 & SSAS Tabular This week Microsoft released a small update to SQL Server 2016, and one of the features that I am looking forward to testing is upgrading…
BI-NSIGHT – Excel 2016 Waterfall Charts – Datazen Updates – Power BI Content Packs (SQL Sentry, Circuit ID) – Power BI Distribution Groups
These past two weeks there has been a massive amount of news and reviews on the updated Power BI Desktop as well as the Power BI Service. I have been reading quite a lot and found some people doing some really amazing things. I honestly feel that Power BI is going from strength to strength. Excel 2016 – Waterfall Charts…
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 – 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 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…