Archive - Blog Posts on Power Query

Data Modelling with OneDrive Source Files - Level: Intermediate Last week I shared how it was possible to easily create an online survey using Excel for O365.  Once such a survey is created, the data can be imported into PowerBI.com and used to create a simple report.  The biggest issue with directly connecting to OneDrive like I showed last week is that you […] 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 you how to quickly and easily create an On-Line Survey that you can distribute to anyone that has an Internet […] Read More
Save PBIX from Power BI Service Under Delivers - This blog post was going to be about how excited I was to hear that there is now an option to download a PBIX file from the Power BI Service to your PC.  Unfortunately all that glitters is not gold.  This new option in the Power BI Service promises a lot but delivers little – […] Read More
Find Duplicate Files on Your PC with Power BI - Level: Beginners If you want to learn new skills using a new tool, then you simply must practice.  One great way to practice is to weave the new tool into you daily problem solving.  If you have something meaningful to do with the new tool, then you are much more likely to be motivated to […] 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, Power Query and Power BI) don’t even know these tools exist, let alone how the tools can help them succeed in […] Read More
Shaping vs Modelling in Power BI - Level: Beginners Power Pivot, Power Query and Power BI are 3 products that are closely related to each other and were all built for the same purpose – enabling Self Service Business Intelligence.  I first learnt to use Power Pivot for Excel, then Power Query for Excel, and finally Power BI.  But there is a […] Read More
Top 10 Tips for Getting Started with Power BI - Level: Beginners I really love Power BI, and I have learnt so much over the last 12 months that sometimes it is easy to forget the challenges I had in getting started. Today I am sharing my top 10 tips on how to get started with Power BI. Build Your Reports in Power BI Desktop, […] Read More
Happy First Birthday Power BI - One year ago today on the 24th July 2015 a brand spanking new BI baby was born.  And its proud parents named the new baby Power BI, and soon Power BI would become known to everyone around the world.  Today is therefore a day to celebrate what a great first year it has been for […] Read More
Measures on Rows – Here is How I did it - Level: Intermediate You may or may not be aware that it is not possible to put Measures on rows in a Matrix in Power BI. But I came up with a trick that makes it possible, so read on to find out how. Measures Can Only be Placed on Columns First the problem. The only […] 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 Excel and the Power BI Service, and makes Power BI even more like you own personal SSAS server. There are […] Read More
Top Tips for Sharing Content Using Power BI - Level: Beginners I have learnt a lot about sharing Power BI content over the last year since Power BI hit the main stream.  A lot of my learning has come from trial and error, and there are lots of things I wish I knew before I started.  Today I am sharing my top tips about […] Read More
Power BI May 2016 Update is Another Cracker - I was super excited by the May 2016 Power BI Desktop update as it had a stack of great new features.  Today I am covering the ones I think are the most useful. They are Conditional Formatting Nudge Objects on the canvas Quick Calcs Customisable ToolTips Improved CSV connector Conditional Formatting One thing I find […] 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
Sydney Modern Excel and Power BI User Group is Growing - In October last year, Iman Eftekhari and I set up the Official Microsoft Power BI User Group (PUG) here in Sydney Australia.  Since then we have gone from strength to strength and as of the time of this post the user group consists of a total of 330 members.  If you live in Sydney and […] Read More
What is Power BI - Level: Beginners This is the third in my “what is” series having previously blogged about “What is Power Pivot” and “What is Power Query”.  This topic is the hardest of the three to give a straight answer, however it is also the most important to understand (as I will explain below). Why Power BI is so […] Read More
Power BI Analyze in Excel – What You Need to Know - Level: Beginners Microsoft announced another awesome Power BI feature recently – Analyze in Excel.  This feature was requested by Avi Singh from PowerPivotPro.com and was heavily supported as a requirement by the community. You can read more about how you can influence future releases at the bottom of this post.  But let’s get straight into […] Read More
What is the Best Training for Business Analysts? - Level: Beginners The rate of change in the tools available to a Business Analyst has never been faster than it is in 2016.  The market is changing so quickly that many Business Analysts (BAs) are not even aware of the great new tools that are available to help them succeed in their jobs and careers.  […] Read More
Power BI Public Story Telling is Pure Genius - Level: Beginners It is now possible to share your (public) reports from PowerBI.com with anyone over the internet for free (currently a free preview), without the need to manage licencing, logins etc (see demo below). Microsoft has been promising this feature for a couple of months now and the speed in which these new features […] Read More
Pin Excel to Power BI Dashboard is Disappointing - In a recent release of Power BI, I was really excited to see that the team had created the ability to pin an Excel workbook to a Power BI Dashboard.  I have been waiting for this and it was high on my list of things I missed most versus SharePoint Enterprise.  However when I tested it out […] Read More
Control Cross Filtering of Charts in Power BI - The team at Power BI is setting a blistering pace of updates and improvements for PowerBI.com and Power BI Desktop.  One of the great improvements in the November 2015 update is the ability to control how cross filtering between charts (and other objects) on the canvas works.  The default cross filtering between charts has been […] Read More