Power BI

[Part 1 of this series can be found here and part 2 here] The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are…

I’m at the PASS Summit this week, and in this morning’s keynote there was a demo of the newly-released Azure Data Studio – a modern, cross-platform tool for managing and querying…

If you are following me on social media, this video will not be new. Two days ago I received my print copy of the book. The book is real 🙂 I was so excited about it, so I had to fool around and create this video. A journey of one year has ended. I would …

A couple of things have happened within the last few days. In short: We have a new promo video We published 3 Data Stories to the Power BI data stories gallery Our Partner Showcase solution has been approved and published on the official Power BI website That’s A LOT of info to digest, but let’s …

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual.This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there are different measures invoked inside the column. The previous would be impossible without this technique....

The older I get, the more consistently I encounter things that make me feel old. And it’s not just the usual things, like those damned kids on my lawn. It’s things like technology. And …

You can easily change a column type by it's relative position. This requires some basic editing of the M-Code and using the Table.ColumnNames formula.

Starting today you can transport canvas apps and Flows in a Common Data Service solution file! This was a major ask from the maker community and now you can package multiple canvas apps and flows into…

As you have learned from an earlier announcement today, you now can leverage the Solution system for canvas apps. This feature greatly enhances our current App Lifecycle story, allowing you to easily …

Today, the PowerApps team rolls out a brand-new sharing experience for canvas app. Check out the new look and feel! Not only is it a lot more responsive and meeting higher accessibility grade, it…

This blog post explains how the ISINSCOPE DAX function works, how it is different from ISFILTERED and ISCROSSFILTERED, and when it can be useful.

I am happy to announce that Custom and Certified Connectors in Power BI are now generally available!OverviewAfter delivering the Power BI extensibility framework, our incredible community has…

We are pleased to announce that the ability to export your Power BI reports to PowerPoint is now generally available

In this quick post you learn how to enable Dataflows in Power BI Service under a Premium Capacity.

In this week's episode of Insight Quest, Brett, the team's lead BI developer and admin, has returned from a trip to the Power BI World Tour in Seattle and been assigned the following three work items …

This is a companion article to my SQL Saturday Johannesburg, SQL Saturday Durban, Power BI World Tour, and SQL Saturday Oregon session: Power BI Design Tips for the Aesthetically Challenged. Below …

Case When data is not extracted from a cleaned up or validated environment, such as a Data Warehouse or Data Mart, the first step is to ana...

Last week I was trying to embed a Power BI report into a SharePoint online page. I wanted users in my organization with a free license to be able to...

Microsoft recently released a new feature in Power BI called “Dataflows”. You may have seen it pop up in a recent release of Power BI Desktop under Home\Get Data\Power BI Dataflows (beta) as shown…

Power BI dataflows, a spectacular Power BI update

If you've ever built an enterprise data warehouse or large-scale business intelligence solution, you understand the effort that goes into building the ETL / data preparation subsystem. Tools like SQL S…

If you've come to this blog to learn more about Power BI dataflows, here are all of the posts I've published to date, in the order they're intended to be read. First of all, here is a set of resources…

By now you probably know that the Microsoft Business Applications Group (BAG) publishes its upcoming plans in its release notes online: https://docs.microsoft.com/en-us/business-applications-release-n…

One of the exciting new preview capabilities in the October 2018 release of Power BI Desktop is support for data profiling in the Power Query editor. Having per-column data profile information availab…

I try to avoid using Excel as a data source when I can. Although Excel has many benefits[1], its limitations[2] make it less than ideal for enterprise BI solutions. Despite this, it feels like I end u…

Now that dataflows are available in preview, you might be run into problems, and be looking for help or guidance. Please do not ask your questions here. Seriously, asking a question in comments on a b…

For the past few[1] months I've been telling people that dataflows will be available soon. They're available now[2]. Don't just take my word for it - you can also ask this guy: Or this more famous guy…

We’re excited to announce the availability of two new query histogram distribution charts. One is bucketed by query durations(ms) and the other is by query wait times(ms). Query histogram…