Power BI

Home/Power BI

Revealing Power BI’s Hidden Gems

by Wyn Hopkins Did you know about these hidden Power BI features? It seems unfortunate that for such an awesome product there are a few user interface features that are very difficult to discover. I have trained hundreds and hundreds of users in Power BI, and I get to experience people hitting these issues over [...]

2019-12-09T16:04:26+08:00Power BI, Power Query|

How to use Icon Sets in Power BI and Excel

If you find the default Icon settings confusing in both Excel and Power BI, you're not alone! In July 2019 conditional formatting Icon Sets were added to Power BI and it caused us to revisit how they work in Excel. In Excel you would highlight a range of numbers and choose Conditional Formatting : Icon [...]

5 Ways to use Power Query more effectively

Power Query is an amazing tool for cleaning and transforming your data to make it ready for analysis in Power BI or Excel. Here are 5 useful hints to help you use Power Query more effectively: Hint #1 – Use the Formula Bar The Formula Bar helps you quickly understand which step you have previously [...]

Read a Range Name, Table or Sheet from all Excel files in a Folder using Power Query

If you have a bunch of Excel files that all have the same structure, you can easily pick a table name, sheet name or range name that exists in all of them and read that one item from all workbooks into a single table using Power Query. It's an incredibly useful tool for situations such [...]

Voice generated Power BI Mobile report

Move over Siri, Alexa Get information from your Power BI reports faster by using your voice. Excel file to a voice generated Power BI Mobile report. Learn how in less than 7 minutes! Here's how to build a voice generated report on a mobile starting with Excel and ending in Power BI Mobile . It [...]

10 Million rows of data in Excel?

Loading 10 million rows of data into Excel We believe it's important that business users of Excel understand what it's truly capable of. Only then can they make informed decisions about if/where to invest in new software, what staff training is required and how the business can be more efficient. Excel is capable of dramatically [...]

VLOOKUP and INDEX MATCH

VLOOKUP v INDEX MATCH - You decide Let's think of VLOOKUP as a screwdriver and INDEX MATCH as a power drill... wait...wait.... I'm not saying INDEX MATCH is faster than VLOOKUP that isn't what this analogy is leading to. If  I need to screw something together I just pick up the screwdriver and hey-presto done.  [...]

Percent of group in Power Query

Percent of Group in Power Query (plus an Excel Table version) Power Query saves you days of time manually manipulating messy data. This leads to improved productivity and efficiency. A quick tip to save you time is to generate a % of group total. It's relatively straightforward in Excel, but it's trickier in Power Query. [...]

Connect to files on OneDrive and Sharepoint

Connect to Excel files using Power Query Power Query can connect to Excel files held in OneDrive for business and in SharePoint. But it's not obvious how. Whether you use Excel or PowerBI this approach will work. Also, for a pure  "M" code approach to SharePoint you can use something like this to get your data [...]

Vote for the Excel and Power BI features you want

Microsoft UserVoice We all want to make Excel and Power BI better. There are new features we'd love to see, and there are existing issues we'd like to fix. Microsoft are listening to users expressing their views via voting on the UserVoice sites. Vote for the features you want A number of experts (including our [...]

MYOB and Excel/Power BI integration

Approximately 1.2 million businesses use MYOB products, this versatile accounting package has several offerings, but one thing they have in common is a less then amazing reporting function and integration with Excel. In 2013 MYOB Introduced a set of Application Programming Interfaces (APIs) for several of its products, making it now possible to extract data [...]