Archive - Blog Posts on Power BI

New Functions – GENERATESERIES, SELECTEDVALUE - Level: Beginner/Intermediate In the August 2017 update of Power BI Desktop Microsoft released the new What If feature (first demonstrated at MDIS in July).  This new What If capability uses two new DAX functions to complete a task that you have always been able to do manually.  You still can of course still do it […] Read More
Happy Second Birthday Power BI - The 24th of July, 2017 is the second birthday for Power BI.  I thought I would take the occasion of its second birthday to reflect on all the great work that the crack Power BI team at Microsoft has done over the last year.   I think it would be a tough job working in […] Read More
Secret Insider Update on New Power BI Features From MDIS - Today I sat through the Keynote session at the Microsoft Data Insights Summit.  As expected, James Phillips confirmed that MS has been holding back a few killer features to announce at the Summit.  Here is the list of new things that are coming that I wanted to share with you – I am truly excited. […] Read More
My MDIS Data Analytics Challenge Entry - I was reading a blog by David Eldersveld last week where he was talking about his entry in the Microsoft Data Insights Summit Data Analytics Challenge.  I originally was too busy to enter however I was inspired by his article and thought I should prepare an entry albeit with only a few days to go.  […] Read More
Microsoft Announces the Return of Export to Excel - At the start of May 2017, Microsoft announced that Export to Excel/CSV would no longer be available to Power B Free users, and would not be part of the new Power BI Premium offering either. Today Microsoft announced that it has listened to community feedback and has agreed to include this feature for all users again. […] Read More
Power BI Free is the Main Problem Here - I am an enthusiastic sponsor of Microsoft BI. I have been fortunate enough to build a new career off the back of the great products Microsoft has developed, specifically Power BI, Power Pivot and Power Query.  Having said that, I am definitely disappointed with the new licensing agreement changes have been released in the last […] Read More
Power BI Licences Changes–The Good, The Bad and The Why - Microsoft today announced that it is changing the way it licences its Power BI service product.  I want to provide my personal view on why it is doing this, what is good and also what is bad about this change. The Problem MS is Trying to Address Let me start by explaining the problem that […] Read More
New Power BI Reports from a Golden Dataset - Last week I wrote an article at PowerPivotPro.com explaining how to create a new report on PowerBI.com that connects to an existing dataset already loaded on PowerBI.com.  I then discovered (thanks to reader feedback) that Microsoft has already delivered a preview of a new feature called “Power BI Service Live Connection”. This new feature allows […] Read More
Which to Use – Power BI or Excel? - Level: Beginners One of my regular blog readers (and graduate of my live training course) Phil Cross asked me last week if I knew of anywhere to find a comprehensive guide for Self Service BI users of when to use Excel vs Power BI to author new data models. I thought this would make a […] Read More
An Introduction to DAX as a Query Language - Level: Intermediate I have written quite a few articles that contain embedded references to DAX Queries and DAX Table functions in the past.  Today I am writing an article that introduces the DAX query language from the beginning so you can learn how to use it and how it will help you to become a […] Read More
Power BI Skills – Thinking of Data in Tables - Level: Beginners One very important concept that Excel users often struggle with when starting on their Power BI and Power Pivot journey is that they need to learn to think about data in tables rather than thinking about data in cells.  In the spreadsheet world every cell can be a different formula or value, but […] Read More
Download Report from Power BI Service to Desktop - I love to celebrate successes with the Microsoft Power BI team, but I am also not shy in shouting out when I am disappointed.  Back on 25th Nov 2016 I blogged about the then new “Save PBIX from Power BI Service”.  At the time I was disappointed in the way it worked because it didn’t […] Read More
The Top 30 Reasons You Should Be Considering Power BI - I wrote this article to be a definitive list of the top reasons you should consider using Power BI in your organisation (in case you haven’t already made the decision to do so).  In fact there is only one thing that worries me about this list, and that is I think many people may be […] Read More
Power BI On Premise – Not in the Cloud! - Microsoft has recently released a technical preview of Power BI that can be installed on premise inside a company firewall and the Power BI reports can be securely published over the Intranet (not Internet) via SSRS.  Today I am sharing my experiences setting up the technical preview for the first time.  I installed the software […] 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 along the journey.  Most of these things are not “right” vs “wrong” – they are more often simply “better”.  I thought there […] 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 what time intelligence is and hence sometimes you don’t even know what to ask.  Often the question is something like […] Read More
Extract Tabular Data From Power BI Service to Excel - 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 covered in great detail in this post). Power BI has an inbuilt export data feature (there is an export limit of […] Read More
Data Modelling with OneDrive Source Files - 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 can’t […] Read More
Easy Online Surveys with Power BI Reporting - 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 connection, and […] 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