Excel - Page 2 of 2 - Excelerator BI

Excel

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

SQL Saturday Melbourne Feb 2017 Materials

Level: Intermediate I am currently in Melbourne for PASS SQL Saturday 2017.  SQL Saturday is an annual one day conference event that occurs in many major cities around the world.  It is focussed on helping …

SQL Saturday Melbourne Feb 2017 Materials Read More

Best Practices for Power Pivot, Power Query and Power BI

Level: Beginners There are many best practices for Power BI, Power Pivot and Power Query.  I know these things so intuitively now that it is very easy to forget how I incrementally learnt these things …

Best Practices for Power Pivot, Power Query and Power BI Read More

DAX Time Intelligence Explained

Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX.  If you are just starting out then the chances are that you may not even be clear …

DAX Time Intelligence Explained Read More

Extract Tabular Data From Power BI Service to Excel

Level: Intermediate Someone asked me a question yesterday about exporting data from the Power BI Service into Excel.  There are a few options to do this however they all have their problems (these problems are not …

Extract Tabular Data From Power BI Service to Excel Read More

Cleansing Data with Power Query

Today I am combining a few techniques to show how to build a robust cleansing approach for your data using Power Query.  This article will demonstrate the following Power Query techniques Joining tables (Merge Query) …

Cleansing Data with Power Query Read More

Easy Online Surveys with Power BI Reporting

Level: Beginners I think today’s article will be of interest to my readers even though it is a little astray from my normally pure Power BI, Power Pivot and Power Query content. I will show …

Easy Online Surveys with Power BI Reporting 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

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 Pivot Crashes? – An Update

Level: Beginners Today Avi Singh and I met with Howie Dickerman from Microsoft to discuss the Power Pivot for Excel Add-In.  You can read the background to this meeting at my blog post last month.  …

Power Pivot Crashes? – An Update Read More

Does the Power Pivot Excel Add-In Crash for You?

Level: Beginners I was chatting to Avi Singh the other day and we were comparing notes about the live Power Pivot training classes we both offer in Australia (me) and the USA (Avi).  One thing we both …

Does the Power Pivot Excel Add-In Crash for You? Read More

Who Needs Power Pivot, Power Query and Power BI Anyway?

Level: Beginners One of the great challenges Microsoft has faced with its “new” suite of Self Service BI tools (particularly Power Pivot) is that most people that could benefit from the holy trinity (Power Pivot, …

Who Needs Power Pivot, Power Query and Power BI Anyway? Read More

Power Query to Combine Web Pages

Level: Intermediate There was an interesting question this week on http://powerpivotforum.com.au asking if there was a smarter way to user Power Query over multiple identical web pages to scrape the data in a single query. …

Power Query to Combine Web Pages Read More

Direct Connect from Excel to Power BI Service

Level: Beginners Today Microsoft announced a great new feature that allows you to direct connect FROM Excel TO Power BI and not the other way around.  This simple change really streamlines the integration experience between …

Direct Connect from Excel to Power BI Service Read More

Scroll to Top