Power BI

The first step we take in every Power BI report, is connecting to the data source. But maybe you have to change your data source after a while. For example when your transferring your solution from…

This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to preserve context from titles in the worksheet grid after you combine multiple tables, as illustrated here: In this bonus exercise you will learn how to address a …

From Tableau to Power BI and Qlik to Alteryx, pick your tool and there’s a good chance you can integrate it with DataRobot. The key lies in the API. One of the most challenging aspects of any data pro…

Dataset size and dataset count in memory are now available in the app

This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. The topics of these bonus exercises wil…

I love these little wins that truly highlight the power of Office 365! Here’s my use case: in the Boston office of Slalom, we have an annual Learning Day that everyone is required to attend. …

The Mapbox Visual for Power BI plugin allows businesses to organize and visualize data and answer critical questions to improve operations.

Well this month has sure been a busy month with a whole host of additional updates for Power BI. I personally am really looking forward to the next few months to better understand how all of this w…

For those who work with primary and foreign keys on CDS and SQL Server, we have added GUID as a first class data type. Although not common, you may want to beat the rush and start updating any formula…

When we connect an app to a SQL Server table that has a column of type time, the values don't show in a user-friendly format by default in PowerApps. In this post we'll go over some expressions that can be used to improve the experience for the app users, by converting from the duration format to a more natural hh:mm:ss one.

Imagine a company where service technicians perform on-site repair of equipment. Inevitably, in doing this sort of work, the technician will need to refer to equipment drawings, service history, past photos, specifications and/or operating manuals. These days PowerApps is fast-becoming a great option for such a scenario because many field workers prefer to use their phone or a tablet. But PowerApps also has some limitations, and right now that is around the display of documents from SharePoint. For a start, it is impossible to display office documents natively in PowerApps at this time, an...

This simple and brief article is about Incremental Refresh setup in Power BI. By the end of this article, you will know more about incremental refresh, its advantages and setup process. What is incremental refresh? Incremental refresh is a feature in Power BI premium which enables more reliable,...

A few months ago, I started a series of posts about “translating” Tableau functionality to Power BI functionality and terminology (FIXED LOD example). Continuing that series, one of the…

Candlestick chart for stock data analysis in Power BI Desktop Power BI Desktop contains a wide range of custom visualizations which helps to represent and analysis of the data with extensive formattin…

We live in a data-driven world. We don't make decisions without consulting as much data as possible, whether we're booking a hotel or playing fantasy football. Yet, many organizations aren't fully cap…

Well, literally, it all started with a tweet from Amir Netz - the father of SSAS and Power BI... The link to the tweet It seems like November 2018 will be a huge Power BI month with many new features …

At Microsoft, our mission is to empower every person and every organization on the planet to achieve more. Power BI makes it possible for every employee in an organization to make better decisions bas…

In the November release of Power BI desktop we introduced a new DAX expression that is really great. Working with hierarchies in DAX have always been a bit of a...

Connect to the latest conferences, trainings, and blog posts for Office 365, Office client, and SharePoint developers. Join the Office 365 Developer Program.

The ability to add columns and measures to display folders in the new Modelling view is one of my favourite features of the November 2018 release of Power BI Desktop: it makes complex models a lot mor…

We have a massive Power BI Desktop update this month. Composite models, which allow you combine direct query and import sources together in one model, is now generally available. Two of the top featur…

The M-Language for Power Query and Power BI is a functional language that is foreign to the classic loop constructions of other languages. Instead, functional programming languages use recursion to repeat expressions. In the first part of this series I show you how to implement recursive functions in M and we take a look at advantages, disadvantages and alternatives of recursive functions.

Back from the days when I was a management student a classic work on strategy,which inspired me was “Strategy Safari” by Henry Mintzberg, Bruce Ahlstrand, and Joseph Lampel. Strategic …

With the recent announcement of dataflows in the Power BI Service, I see more people will be looking to better understand and leverage dataflows by using the M language which is available in Power …

I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) view of your Outlook diary to see wh…

In the recent webinar Using SVG Images in Power BI, I showcased dynamic SVG measures displayed in the Table and Matrix visuals. Both of those visuals are limited to displaying images in a small gri…

The idea of creating a Power BI custom connector for the Power BI REST API is not a new one: Miguel Escobar wrote one earlier this year (see here for the source code and documentation). However the Po…

Navigating the sea of data One of the many things which amaze me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For e…

Announcing the the Flow checker, which provides an improved validation and error correction experience. You can now get in-context help on where the errors and warnings are in your flows and will be g…

We are excited to share you the November 2018 version of Power BI helper with many interesting features. With this version, you get the list of all pages and list of all bookmarks. You can find all bo…