Do you know how to use Multiple Disconnected Slicers in Power BI?
I had previously blogged Power BI – Using a Slicer to show different measures where I showed the steps on to have a different measure based on a slicer selection. I got a few comments from that blog post, where people were asking if it was possible to have multiple Slicers which could be used. If you are reading this…
Power BI RoundUp – Export to PDF & On Demand Email Subscriptions | Premium Capacity Metrics App Update | Difinity Conference | Power BI APIs with Service Principal | Bulk Operations in the Admin Portal | Webinar on Personal Bookmarks in the Power BI Service
Hi there, I cannot believe it is already February. This year is already starting to fly by. Please find below my weekly Power BI Round Up. Export to PDF & On Demand Email Subscriptions As you can see above you can now schedule your email subscriptions. Not only that but coming to the Power BI Service is the ability to…
Where can I find all the data sources for my #PowerBI report?
I have found that at times people get other Power BI reports and are not sure what data sources there are in the file. As well as which data sources are connecting to what? In this blog post below, I will show you where you can find all the data source details. In my sample PBIX I have connected to…
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…
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 – 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…