Power BI

Using a Web API is a convenient way to expose and consume data over an Internet connection. Exercising some essential design patterns, understanding and working with the Power Query Formula F…

For a while now I’ve had an idea stuck in my head: wouldn’t it be cool to build a Power BI solution where a user could enter data into an Excel workbook and then, as soon as they had done so, they …

Power BI now includes eight built-in themes in addition to the countless JSON variations that you could import. If you are interested in the hex color values in order to use them in Power BI or els…

A quick update: The print version of the book will be released in 4 days! It may take few extra days to reach the major distribution centers. On Amazon there are some data sync glitches right now, so …

We live in a busy and stressful era. In our daily business we can not wait for weeks, months or even longer to get our insights. So we need to deliver faster. Therefor we are working agile to reali…

It’s a very busy week at Microsoft Ignite 2018. We’ve been working on all the enhancements we previewed at SharePoint Conference in May 2018, and we hope you’ve been able to enjoy the featured role for SharePoint, PowerApps and Flow in some of our keynote demos this morning, and available for repla...

Webinar covering Power BI advanced data prep with dataflows—a suite self-service low-code/no-code features and capabilities for business analysts to easily process and unify their data and store it in Azure-based data-lake storage.

I have heard this question come up now and then where someone wants to separate the names and columns seen by users from the names and users used in SSAS...

Playing around with Microsoft Flow recently, I was reminded of the following blog post from a few months ago by Konstantinos Ioannou about using Flow to call the Power BI REST API to refresh a dataset…

Editing the look and feel of apps can seem like a time-consuming task. However, with some easy tips on linking controls redesigning apps can be incredibily easy. Linking controls empowers app developm…

Tony Phillips SharePoint Designer

This blog has been very silent over the past few months as all of my attention and free time was spent working with a small startup focused on delivering a commercial solution based on Power BI. I’…

We analyze top UI patterns and latest design trends, and provide actionable recipes for various user tasks

I was recently architecting a solution for a customer that required a combination of self-serve and IT governed Power BI reporting. They wanted a simple a process to create, edit, and manage their content – without the danger of unvalidated reports being published into the production app workspace. The customer’s existing process was very manual […]

Today, we’re excited to share the latest updates for OneNote across Windows 10, Mac and online. From cloud file attachments, tag search, to Emoji keyboard and customizable autocorrect, we will be rolling out these updates in the coming weeks, so read on to find out more. Keep your work in sync wi...

We are pleased to announce Beta release of powerbi-visuals-tools v3. This Beta release brings a lot of new features for Custom Visuals development experience. With new Typescript v3 and ES6 modules support, users are able to integrate modern versions of all popular libraries like D3 V5 or others. ...

I am sure that there were a few people who were eagerly waiting for the Power BI Desktop Update for October 2018. I sure was one of them and it was well worth the wait. Please read all the details …

Power Query is amazing for cleaning, shaping and analyzing numerical data, buut it can also help with analyzing text that is unstructured.

Are you using Power BI incremental refresh? Have you had it not work even though you set everything up? In this video, Patrick looks at a scenario where Power BI incremental refresh was broken. He then looks at a way to get Power BI incremental refresh working properly.

Power BI Report Server was first launched in June 2017 as our on-premises server product, giving customers the ability to adopt Power BI today while preserving their flexibility to move to the Power B…

Possibly the biggest scalability feature (literally) in the history of Microsoft BI is actually here! The Power BI Desktop feature summary announced aggregations built on composite models is now suppo…

Premise In my previous post, I demonstrated how to fetch bulk items from a SharePoint List to PowerApps. In this post, I’ll demonstrate, how to pass argument/value, from one PowerApps screen …

Working with big data, even massive data can be a real challenge in Business Intelligence platforms. #PowerBI is no exception. The new aggregations feature in Power BI looks to solve that problem. We sit down with Christian Wade, the Power BI PM that brought us Clicky Clicky Draggy Droppy, and who is the PM for […]

I recently was troubleshooting a performance issue for a customer where their LiveConnection was slow when connecting to an On-Premise SSAS Tabular server via the On-Premise Data Gateway. One of th…

We are back to finish our discussion on the visualizations for Comparing Rows in Power Query! How to visualize the prices and daily changes The two metals have very different price ranges so it is difficult to see them in one chart. The daily changes are relative so they can be used to compare the price behavior

Today Microsoft released the October 2018 update of Power BI Desktop. One of the fabulous new features that has been released is the ability to get a visual profile of your data in Power Query BEF…

You know it and I know it. Data quality is a BIG problem that reduces the business value of BI. ETL practitioners will probably recall that SSIS includes a comprehensive Data Profiling Task but it is …

This month’s update for Power BI Desktop filled with both small and large improvements across the entire product. One huge update is support in the Power BI service for both our composite model and ag…

I have an app in development that is a long list of values that includes a column that has intermittent values. Using a check box, I'd like to filter the gallery to show only those values that have an intermittent value also assigned. To be clear, the gallery would show the entire list when the ch...