BI-NSIGHT – Power BI (Mobile App Update, Prevedere Content Pack, Visuals, Where is my Data Stored) Excel – (Power Query Updates)
Here are this week’s updates, which there are quite a few and I have no doubt that there might be some more updates released tomorrow or in the coming days. Power BI – Mobile App Update There have been quite a few updates with regards to the Mobile App in for Power BI and Reporting Services. It is great to…
BI-NSIGHT – Power BI (May Service Update, Q&A for Enterprise Gateway, Solution Templates, UserName() in Power BI, Local Excel Files Upload, Download Dashboards / Reports to .pbix file, Forecasting Feature, Webinar Intro to Power BI for the Excel User – Newsletter
Here are this weeks updates Power BI – May Service Update There is a whole host of updates to the Power BI Service this week, and some great additions. The first improvement is the increasing in the file size to 1GB. And whilst we all know that the compression is really good with Power BI and Power Pivot, there are…
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 – 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…
Error: An Item with the same key has been already added – Unable to load the tables in the Power Pivot Window
NOTE: First thing to do is to make a copy of your Excel Workbook, before making any changes to your Power Query Source. If you do NOT, and change your Power Query source, your Power Pivot Model could become unusable! 1. I had an issue where if I changed the Power Query source from a CSV after I made changes…