Power BI

I have written quite a few articles about Tabular Editor over the last few years. I recently started using Tabular Editor 3, and I absolutely love it. Buying this product is one of the easiest ways you can significantly improve your Power BI Data Modelling productivity. For US$100 per year [...]Read More »

In this blog post you will learn how to set up a custom connector for a custom API hosted in Azure using Azure AD for authentication.

We are excited to announce the portals search powered by Dataverse search API now available for public preview.

This article gathers all the answers into one place. I will show you an example of how to view SharePoint document library files, folders and subfolders in Power Apps.

Companies need an easy way to aggregate customer feedback that nowadays can come from multiple channels (like email, support incidents, forums, or Twitter for instance). This is part three of a 3-part weekly series on some common ways to get using AI Builder.

As a Power BI administrator you want to see what’s happening in your tenant right now: who’s running queries, which datasets are refreshing and so on. That way if a user calls you to co…

Late last year I was spending some vacation days playing with one of my favorite personal data sets[1], and I realized I needed a better date dimension. So I asked for one. A bunch of folks from th…

When used in a composite model, calculation groups show a very unique behavior that a good DAX developer must understand well to build sound models. In this

Back in 2020, I released the first version of the Power BI external tool to document your Power BI data model. Since then, I wrote a lot about this topic, such as why adding descriptions to everyth…

In a recent post I mused about problem domains and solution domains, how they’re context-dependent, and how interesting things tend to happen at the intersection of a problem domain and a sol…

(if you downloaded this before Jan 1st 2022, please re-download!) This template will allow you to customize your theming (down to the control-level),

This branding template for Microsoft Power Apps will allow you to customize the theming and branding of your App down to the control level.

In this post, we are going to explore one of the OpenAPI extensions, Dynamic Schema (x-ms-dynamic-schema), to extend the functionality of a custom connector

Power BI dataflows (PBI dataflows) is a powerful data prep tool for you to transform data and reuse them in other places downstream. At the same time, while Excel is very popular among business use…

Transform the way of presenting your KPIs, understand the context behind the values within seconds, and tell your company's story.

Another Short blog on my favorite topic, High Concurrency, Low latency Interactive BI Workload, I can’t test everything, but so far, I am impressed by BigQuery BI Engine and Snowflake on Azur…

The Black Scholes formula returns the value of European put and call options. See how to calculate this with the M language in Power Query.

I'm trying to revise for the Power BI 70-778 exam by working through the reference guide. To go through the worked example I need to connect to...

Power BI Wide World Importers demo pbix provides a sample data model. Want a solution to showcase to a potential employer or to test new features?

A fictitious retail demo dataset used for presenting Microsoft Business Intelligence products.

I started my Power Apps blog in June 2020 with no expectations. All I wanted was a place where I could write about the cool things and to document best practices.

Power Platform requests are not an inexhaustible resource. How we can limit their numbers in our solutions?

Today, we are pleased to announce an Automation CoE Blueprint which customers can use to setup an automation program (RPA and other hyperautomation scenarios) in their organization and a limited private preview of Automation CoE Starter Kit, which is an implementation of our best practices (HEAT) that can be customized by organizations for their own needs.

Last month at Ignite, we announced a set of collaboration capabilities across Power Platform. Today, we are excited to announce even more features within commenting on Power Automate. Now, you can at-mention your co-workers in your comments  and have others receive email notifications when you do so.

The December 2021 Power BI Desktop update introduced a long-awaited upgrade to the partitioning and Incremental Refresh feature set. The update introduces Hybrid Tables, a new Premium feature that …

This post will provide resources for getting started with the new PowerApps component feature. By: Mehdi Slaoui Andaloussi, Principle Program Manager Before we delve into individual components, I would like to share 2 guiding principles we used as much as possible when building these controls. 1) ...