DAX (Data Analysis EXpressions) is fundamental to Power BI. And whilst it is possible to use Power BI without knowing how to write DAX, much of the magic of Power BI will be lost to you. Learning how to write DAX is the best move you can make in order to start making the most … Read More →
This article is the first in a series of blogs intended for newcomers to Power Query. It will give you an overview of what Power Query is, what it can do and how it fits into the overall Power BI framework. Subsequent articles in this series will dive into more detail, revealing how to achieve … Read More →
Power BI Desktop, previously known as Power BI Designer, is now out and freely available for download from Microsoft. This is not a preview release, it is a full on GA release of what promises to become an essential tool in the toolbox of many self-service BI developers and consumers alike! Microsoft saved a huge number … Read More →
Finally, the MS Power BI Public Preview is available to non-US based entities. This product represents the future of Power BI and on first looks, it is very promising. All the Power BI tools embedded in Excel will continue to be supported and enhanced, which is great and in addition to that, there is the … Read More →
If you haven’t yet used Power Query and you are pulling data into Power Pivot, you are missing out on a real gem! I have been involved with Power Query/Pivot/View for some time now but just recently have been using Power Query extensively to pull data extracted from a corporate SAP BW system into Power Pivot … Read More →
Welcome to Power BI Pros This website is dedicated to providing information about the Microsoft Power BI suite of tools, but more importantly, providing an outlet for anyone who has an interest in these tools to ask questions, post articles, provide advise and generally, participate in discussions about Power BI. The intention is to provide … Read More →