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 […]
Level: Intermediate In this article I am going to write about the ALL() function, show how it works and explain a common use case. I will also cover the unexpected behaviour that occurs when using the ALL() function in Power BI Desktop – more on that later. For this article I […]
Level: Intermediate Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data). The new capability makes it easier to combine multiple copies of similar workbooks into a single table without hand coding M Functions, […]
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 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 […]
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 […]
2 fabulous new updates again in the April update of Power BI Desktop. Here is my quick review so you can see how great these things are. Quick Measures Quick measures are designed to help you get started with DAX, without knowing any DAX! OMG I will be out of […]
Some time ago I developed a tool that allows you to automatically connect a local Excel Pivot Table to a local running instance of Power BI Desktop. You can read that original article here if you like. It works kind of like Analyze in Excel but using Power BI Desktop […]
Level: Intermediate This is the final article in my series about DAX as a Query Language. In my first article I introduced DAX as a Query Language and then in my second article I went in deeper to the specifics on how to use some of the more useful DAX query […]
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 […]
Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular. The technology is essentially the same across all of these products so I will generically refer to Power […]
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 […]
Level: Intermediate I was helping a user on http://community.powerbi.com this week. The user had a list of service desk tickets for multiple customers and the requirement was to identify when a customer opened a second new ticket within 7 days of closing a previous ticket. This is not an uncommon scenario […]
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 […]
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 […]
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 […]
Edit Feb 2017: I am very excited to discover that download report now works as I would expect. 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 […]
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. […]
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 […]
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 […]
Excelerator BI | © 2023 | Sitemap