Tools - Excelerator BI

Tools

Power BI APIs for Non-Programmers

Level: Intermediate There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar.  I don’t always read the more technical announcements because I don’t have a highly technical background.  …

Power BI APIs for Non-Programmers Read More

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) …

Create a Planning View of Your Outlook Diary in Power BI 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 …

Visually Appealing Power BI Reports 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 …

I’m Presenting at SQL Saturday Melbourne and Sydney 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 …

Changing Defaults in Power BI 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 …

Extract Table Size from Power BI Desktop Using DAX Studio 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 …

Measure Dependencies in Power BI 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 …

DMV to Extract Measures from Power Pivot 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 …

How to Find Overlapping Pivot Tables 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 …

Power BI Desktop – Memory Usage 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 …

How to Document DAX Measures in Excel 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 …

Import Tabular Data from PDF using Power Query 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 …

Excel Workbook Connection to Local Power BI Desktop 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 …

Power BI Personal Gateway Explained 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 …

A Fabulous new Excel Add-In for Power Pivot Read More

Scroll to Top