Archive - Blog Posts on Power Query

64 Bit Power BI Desktop with 32 Bit Office? Can do! - As many of you would already know, 32 bit applications do not always play well with their bigger sibling,  64 bit applications. There are lots of “under the hood” files and applications that are always designed to be either 32 bit or 64 bit – not both.  In the case of Microsoft Office, you must […] 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
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
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
Use Power Query to Manage Dropbox Space - Level: Beginners I got this dreaded Dropbox email recently as shown below. I needed to clear out some of the files I have loaded in Dropbox so I didn’t have to upgrade my account.  It occurred to me that I could make this process a lot easier by using Power BI to quickly show me […] 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
Query Dependency View in Power BI Desktop - I have been on holidays taking a much needed break from work, so it has been very quite on my blog over the last few weeks.  But I am back now! I woke up this morning to a very pleasant surprise – Microsoft has delivered the long waited for Query Dependency View in Power BI […] 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
Conditionally Refresh Queries in Power BI - There was a great new feature that snuck in unannounced to the July release of Power BI Desktop.  It was only a tweet by my colleague Imke Feldmann from http://www.thebiccountant.com/ that I was even aware it was there. Include in Report Refresh When you look in the Queries pane in Power BI Desktop, you will […] 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
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
Conditional Columns in Power BI Desktop - Level: Beginners Microsoft recently announced a new conditional column feature in Power Query (Power BI Desktop version) that warrants a blog post.  This feature makes the process of creating banded columns much easier for the average user.  I blogged about banded columns using DAX here, and now there is this second, potentially easier approach.  In […] 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
Many to Many Relationships in DAX Explained - Level: Advanced (Level: Advanced, but explained in detail so everyone can understand) There is a lot to learn in DAX if you want to be a ninja.  A couple of the more complex and important things to learn and understand are filter propagation and context transition.  It is not so much that you need to be […] 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
Moving From Excel to Power BI–PASS Presentation - I was recently a presenter at the PASS BA Webinar Marathon – Dec ‘15.  This was an online Webinar with a total of 7 separate presentations from various experts across the industry.  My topic was “Moving from Excel to Power BI – A Business Analyst’s Perspective”.   The session was recorded and is available to view […] Read More
The Future for Microsoft BI is Bright - I just finished watching the presentation from James Phillips – GM of Power BI at Microsoft from PASS Summit 2015.  He talks about the incredible progress that Microsoft has made this year in the BI space, particularly with Power BI, but importantly about the future of Business Intelligence at Microsoft. Embed Excel coming soon Yahhh, […] Read More
Power BI Visuals Gallery is a Game Changer - Level: Beginners No software company can build every single feature that everyone wants to see all at once.  Ultimately there has to be some prioritisation, and along with the prioritisation comes compromises and ultimately disappointments for some (many?).  Back in July 2015, Microsoft started a chain of actions and announcements that will prove to be […] Read More