The Complete Power BI Infographic – Update for Dec 2018
I recently had a look at my last version of my Infographic and I realized that I had not updated it for a few months and there has been a lot of incredible additions to the Power BI ecosystem. My infographic not only contains the details outlined below, but all the prior updates too. It is incredible to see how…
Power BI RoundUp – Power BI Desktop Dec Update – Dataflows Integration with your own Azure Data Lake – Business Application 2019 – Developer Update Nov 2018 – Windows App Update
It appears that there is one last massive push from the Power BI team before the end of the year. I would consider this my early Christmas present, so please enjoy and read below. Power BI Desktop Update Dec 2018 Once again it is another big update to Power BI desktop. Reporting I really like the smart guides that are…
Converting Multiple Items into One Row in Power Query
I was working with some external data where I had a list of Australia postal codes, the challenge is that there are multiple suburbs that are part of one postal code. Below I am going to show you how I took the multiple suburb names and put them into a single row, which would then allow me to have a…
Power BI RoundUp – Ask a follow up question, Help Improve Power BI
As I am typing this I am wondering if tomorrow I will have to update it with the new Power BI Desktop features, or if this will be coming out next week! Here is my weekly Power BI RoundUp Power BI – Ask a follow up question If you are not aware there is now new functionality in Power BI…
Power BI – How to Configure “Send Refresh Failure Notification email to Distribution List (Multiple Users)” for Dataset refreshes
As it currently stands when I setup a dataset refresh it only emails me when it fails. I was recently at a customer where there is a team of Power BI Developers, and I wanted to find a way that all the developers would get a copy of the dataset refresh failure email. This would ensure a single point of…
Multiple conditions for a conditional column in Power Query
I am often working on datasets where there is more than one condition for a conditional column. And whilst the GUI based Conditional column is really good, it currently does not have the capability for multiple conditions. In this blog post below, I will demonstrate how to achieve this. In my example below, I have a table that has got…
Power BI RoundUp – Help Shape the Future of Power BI – On-Premise Update for Nov 2018 – Modeling View – Analysis Services is 20 years old!
Here is my weekly roundup, and whilst it has not been as busy as the past few weeks, there are still some awesome updates. Power BI – Help Shape the Future of Power BI I always think it is really important to provide feedback, especially when they are asking for assistance. You can click on the link above to take…
Refreshing data in Power BI from SQL Server Read-only or Secondary Replica’s
I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M connector, it is available in the OLE DB connector. NOTE: This could potentially be used for a whole host of other OLE DB providers NOTE…
Power BI RoundUp – (Nov 2018 Desktop release – AI Capabilities for Power BI)
Well this month has sure been a busy month with a whole host of additional updates for Power BI. I personally am really looking forward to the next few months to better understand how all of this will evolve and assist customers on leveraging their data assets. Power BI – Nov 2018 Desktop This was yet another massive update to…
Power Query – A function to remove spaces within Text values
UPDATE: 19 Nov 2018 With the recent announcement of dataflows in the Power BI Service, I see more people will be looking to better understand and leverage dataflows by using the M language which is available in Power BI Desktop, Power Apps and Microsoft Flow. I had a great response to this blog post, and both Ted and Daniil had…