Power BI RoundUp | Time-Based Scheduling for Email Subscriptions | Power BI Report Server Update | On-Premise data gateway in the Power Platform | Monetization option for Power BI Custom Visuals
It is great to be back and already into the swing of a new year. 2019 has already started with a lot of new features already coming into the Power Platform. I am looking forward to the year ahead and no doubt will see a lot of new features coming. Here is this week’s Power BI RoundUp Power BI –…
How do you quickly change Text Size or other Visual Properties all at once in a Power BI report?
I was working on a larger Power BI report and there were quite a lot of tables, where the text size needed to be changed. Using the new search box feature in the Formatting options I searched for Text. This then gave me all the options where I had a text value as shown below. Yes, there are more text…
Are my DirectQuery Tables still in DirectQuery Mode, how to ensure they stay that way?
I have been doing some work with Power BI Composite models, and what I have found is that often the DirectQuery table can be changed to an Imported table. I personally feel that this blog post will be an important reference for me and hopefully others when you start to use Power BI Composite Models, to ensure that the DirectQuery…
Power Query – Changing DateTime columns data types to Date without specifying the column names
This blog post I will demonstrate how to change a DateTime column data type to Date dynamically. You might be wondering what I mean by dynamic, this means that I will not specify any actual column names. The code will find the column names based on their data type. For me this has been a challenge to get it working,…
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…