Archive - Blog Posts on Tools

Create a Planning View of Your Outlook Diary in Power BI - I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) view of your Outlook diary to see what is happening (think forest, not trees).  In the past I have used […] Read More
Visually Appealing Power BI Reports - One thing I often get asked is “How do I create good looking Power BI Reports?”.  This is a very good question and unfortunately the answer is not straight forward.  I like to think of the visual appeal as the “Art” of communicating data insights.  The other major consideration is “what and how” to communicate […] Read More
I’m Presenting at SQL Saturday Melbourne and Sydney - I’m presenting again this year at SQL Saturday Melbourne (30th June 2018) and Sydney (7th July 2018).  My topic this year will be “DAX as a Query Language“. What is SQL Saturday? SQL Saturday is an annual 1 day event that is held in many cities around the world.  It is a day when SQL professionals take a […] Read More
Changing Defaults in Power BI - Changing Defaults In March 2017, the Power BI team delivered a new feature that allowed you to change the colour defaults in a Power BI report using a custom colour theme.   I wrote a blog post over at PowerPivotPro.com at the time.   The drawback of this feature, as it was back in March, was that you needed to […] Read More
Extract Table Size from Power BI Desktop Using DAX Studio - I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others.  I have covered the basics of DAX Studio in the past so I wont cover this detail again here. The latest version of DAX Studio can be […] Read More
Measure Dependencies in Power BI - Update 21 Feb 2018: There are 2 versions of this localhost workbook. One works with the downloadable version of Power BI Desktop and the other works with the Microsoft App Store version.  There were some technical issues in late 2017, but as at Feb 2018 everything seems to be working fine again. I was chatting […] Read More
DMV to Extract Measures from Power Pivot - I have written articles before about how you can extract measures from a data model using DAX Studio and also using Power Pivot Utilities.  These are both excellent tools in their own right and I encourage you to read up on those previous articles to learn more about these tools. Today however I am going […] Read More
How to Find Overlapping Pivot Tables - A client contacted me recently and asked me to solve a problem for them.  They have a large Power Pivot Excel workbook with lots of Pivot Tables.  All was good except sometimes when they refreshed the data, the newly loaded data changed the shape of some of the pivot tables causing at least one of […] Read More
Power BI Desktop – Memory Usage - Some time ago I developed a tool that allows you to automatically connect a local Excel Pivot Table to a local running instance of Power BI Desktop.   You can read that original article here if you like.  It works kind of like Analyze in Excel but using Power BI Desktop running on your local PC […] Read More
How to Document DAX Measures in Excel - Level: Beginners I often get asked if there is an easy way to create documentation for DAX measures when using Power Pivot for Excel.  I am not a big fan of documentation for the sake of it, but I do see value in having “some” appropriate level of documentation.  I think a good balance of […] Read More
Import Tabular Data from PDF using Power Query - Level: Intermediate [Edit: Sept 2018] Microsoft released the preview version of the PDF Connector in Power BI. This is another instance to show that Microsoft is listening to the community to add or improve the Power BI features. As this is yet a preview feature, you need to enable it under the Previews list in the […] Read More
Excel Workbook Connection to Local Power BI Desktop - Today I am sharing an easy way to use Power BI Desktop as a SSAS tabular server on your local PC.  I find increasingly that I am building data models in Power BI Desktop and yet I still want to use Excel to analyse the data some of the time.  If I load the PBIX […] Read More
Power BI Personal Gateway Explained - Level: Intermediate One of the many excellent sessions I attend this week at the PASS Business Analytics Conference in San Jose was a session titled “Get Latest Insights by connecting your data using Power BI Content Packs and PBI Gateways”.  The title was interesting but the content presented by Dimah Zaidalkilani and Theresa Palmer-Boroski (both Program […] Read More
A Fabulous new Excel Add-In for Power Pivot - I’m really excited to share with you a new Excel Add-in that was authored by Bertrand d’Arbonneau and has recently been made available via SQLBI.com The Add-in called Power Pivot Utilities combines a number of existing tools into a single new tool bar in Excel as shown below (Excel 2013 and 2016 only). Everything could […] Read More