How to get one table to refresh in a Power BI Data Model
I was recently working on a large Power BI Data Model and I did not want to refresh the entire data model for my updated dataset to come through. This would mean refreshing the large Fact table with a few million rows and a complex underlying TSQL query. All that I required was to get a new value in my…
Power BI RoundUp – End user filter export capabilities | Template Apps | Developer Community Update
Welcome to another Power BI RoundUp, and fortunately this week has been a quieter week, which has worked out well because I have been attending the Difinity Conference in New Zealand where I have both presented on Dataflows. I also attended a lot of great sessions and met new and existing people. Here are the updates End user filter export…
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…