Power BI

It’s Day 15 of my #24DaysPowerPlatform! And it’s time for some mobile apps! During the last days I’ve shown you some examples of what is possible with the members of the PowerPlatform – but everything…

Welcome to today's PowerPlatform blog post! Christmas is approaching very fast and with the use of the PowerPlatform tools I would like to build a Christmas WishApp using PowerApps, PowerBI and Micros…

At the heart of every a Business Intelligence reporting solution is a data model, to optimize queries and enable ad hoc report interactions. Data modeling technology has evolved quite a lot over the p…

A few recent posts have touched on different aspects of how dataflows have capabilities that aren't exposed in the current preview user experience in Power Query Online. This is true of Power Query "M…

How to Create an AAD Account for Power BI Step One: Navigate to portal.azure.com to create a new tenant account using your company account (or create a new one). Step Two: Click on "Azure Active Directory" in the left menu. Step Three: Choose "Create a Directory" on the bottom right...

It appears that there is one last massive push from the Power BI team before the end of the year. I would consider this my early Christmas present, so please enjoy and read below. Power BI Desktop …

Here I am showing some keyboard shortcuts in the Advanced Editor of Power Query Editor in Power BI Desktop, as well as show how to enable a mini map!

See a map of the Wisconsin 2018 midterm election results from data provided by John Johnson.

Ok, finally it is done! This is a side project that I have been undertaking on and off for the past 2-3 months, after getting inspired by Andy Kriebel’s (t | b) Tableau project – Visual Vocab…

You can use custom Power Query “M” functions in Power BI dataflows, even though they’re not exposed and supported in the preview Power Query Online editor to the same extent they …

I was chatting to a few of my Power BI buddies during the week about when we thought the December 2018 update would be released. It seemed to me that under normal circumstances the new version is …

December is a huge month for us in terms of accessibility. With this release, the entire product is completely accessible for both report consumption and report creation. We are also previewing one of the most asked for features related to Q&A, support for live connect! We also have lots of smaller improvements across the product, such as customizable tooltips for buttons and a larger DAX formula bar.

While you have been building stunning applications on PowerApps, you’ve requested a way to view the latest enhancements and new features that our team is releasing each week. Today we are launching PowerApps Weekly Release Notes. This will give you visibility into the latest features and optimizations that we’re shipping on a weekly basis.

Makers can now extend the power of WYSIWYG, low-code customization, offered by canvas apps, to model-driven forms. Using embedded canvas apps makers can easily design and create rich visual…

Reference information for the Color enumeration and ColorFade, ColorValue, and RGBA functions in PowerApps, including syntax and examples

I was working with some external data where I had a list of Australia postal codes, the challenge is that there are multiple suburbs that are part of one postal code. Below I am going to show you h…

One key aspect of Power BI dataflows is that they store their data in CDM folders in Azure Data Lake Storage gen2.[1] When a dataflow is refreshed, the queries that define the dataflow entities are ex…

It has been a while since I written a blog post, even my ten years old daughter started teasing saying “Motionless blog”, so decided to get back to blogging with a…

Aggregations are speeding up the model. However, the aggregated table is not just one table, It can be multiple layers of aggregations. Aggregation by Date, aggregation by Date and Product, aggregatio…

I'm not the only one who's been busy sharing news and content this weekend about the integration of Power BI dataflows and Azure data services. Check out these additional resources and share the news.…

Connect with experts, collaborate with your community and maximize learning opportunities at Microsoft Business Applications Summit, returning June 10-11, 2019 in Atlanta, GA. Back for its second year…

We are very excited to announce the public preview of Power BI dataflows and Azure Data Lake Storage Gen2 Integration. Business analysts and BI professionals can now exchange data with data analysts, …

One key aspect of Power BI dataflows is that they store their data in CDM Folders in Azure Data Lake Storage gen2.[1] When a dataflow is refreshed, the queries that define the dataflow entities are ex…

Learn how to connect Power BI and Azure Data Services to share data and unlock new insights with a new tutorial.

In this post, I will explain the default search that the default app gives and the alternatives available and the issue of delegation. This post is to support my session at SharePoint Saturday Cambridge 2018 and is to cover the issues of filtering data based on a search box. This post uses a simple app […]

Recently I’ve been doing some more investigations into how data privacy settings work in Power BI. This is a subject I’ve blogged about in great detail already in a series of posts last year, but t…

Have you ever asked yourself, “how can I increase the performance and reliability of my customizations and extensions?” and you just didn’t know where to start. Or the pressure to meet those new…

very recently, when I was part of a pre-sale activity , my manager asked me to propose a data analytic solution with least amount of technologies as well as least effort and cost. So my obvious ans…

Join us for a Tour of an improved Power BI navigation experience makes it easy to monitor and analyze your key business metrics.