Power BI

Often when we set up a Business Application based on a Dataverse database, we are asked to make data available for reporting purposes or simply to feed a third-party database that will be consumed …

Azure Synapse Link (earlier known as Export to Data Lake Service) provides seamless integration of DataVerse with Azure Synapse Analytics, thus making it easy for users to do ad-hoc analysis using …

Model-driven apps and Microsoft Dataverse diagnostics and performance data can be monitored in an Azure Application Insights resource. On a high level, you can report user activity with specific forms and it will allow product owners to understand adoption blockers and drivers.

After I post several posts about Custom Web API (Dynamics CRM: Simplify Development with Custom API for Reusability and Get Environment Variable in a Flow using Custom Web API). You should be …

Data sharing has become critical in the modern economy as enterprises look to securely exchange data with their customers, suppliers and partners. For example, a retailer may want to publish sales data to its suppliers in real time, or a supplier may want to share real-time inventory. But so far, dat

The popularity of Power BI has increased dramatically in the past few years. I am seeing an increasing number of enterprise customers who built complex composite models combining import tables with DirectQuery tables. Many users have asked questions on how DAX queries and measures are tran

Learn how Power BI approaches its site reliability model.

I’m excited to share a new whitepaper that describes the Power BI team’s approach to maintaining a reliable, performant, and scalable service for our customers.

Learn how to perform fuzzy grouping and matching in Power BI and Power Query in a few steps described in this article and video

Recently I started a blog series on different topics that come into play when you want to transform a local (small scale) solution into a global (enterprise) solution. I started this series explain…

Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the non-blank rows.

In this article I will show you how to write Power Apps custom functions and unlock the power of reusable code.

Don't repeat yourself! In this article I will show you how to make a Power Apps navigation menu component with the same style as MS Teams.

As promised, today I am sharing with you the process I went through to build the COVID report I shared in my last article. One of the best ways to learn and improve your Power BI skills is to practice. The best way to practice is to find something you [...]Read More »

This blog post compares the logging capabilities between Power BI Premium Per User and Azure Analysis Services.

The workload Roadmap is an indispensable part of an organization's ongoing Power Platform adoption. It is a prioritized backlog of workloads that are candidates for migration to or new solution builds on the platform. It allows the organization to project the technology's business value over time, a

I’ve been thinking quite a bit lately about Power Platform as one of the three principal components of the one Microsoft Cloud, alongside Azure and Microsoft 365 of course. This is particularly important in more complex data ecosystem, one of the enterprise management dimensions you’ll find in the P

Performance Insights, a new feature to help you improve the performance of your Model-driven apps, is now available in public preview!

Today, we published new guidance documentation: Overview of using Azure ExpressRoute with Microsoft Power Platform | Microsoft Docs. This guidance helps you understand and set up ExpressRoute specifically for Power Platform.

The June refresh for Pac CLI and VS Code extension

Microsoft Teams has built and delivered solutions to enrich virtual experience across the spectrum of communication needs, from 1:1 meetings and calls, to webinars and broadcasts. Last year we introduced NDI-Out for Teams, enabling production companies around the world to harness the power of Teams—...

Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns from tables is a very common challenge of data-cleaning. The tutorial in mention, which happens to be one of our most popular tutorials on DataChant, addressed […]

Welcome to the July update! This month we are making small multiples generally available, as well as the new model view and sensitivity labels in Desktop. Also, we have a new preview for streaming dataflows. There is much more, so read on!

In this part, we will start debunking the myth that the Power BI is the "visualization tool only". We will get our hands dirty and start profiling and shaping the data using Power Query Editor!

Power Bi ya tiene un buen tiempo en el mercado. Lo cual implica que en más de una oportunidad los analistas necesitamos partir desde un modelo previamente construido y no comenzar de 0 en un proyecto...

Cierto es que construir un modelo de datos detalladamente para llegar a la estrella deseada hace de nuestro modelo la mejor práctica para su mejor funcionamiento. A pesar de ello podemos caer en la...

Algo que había esquivado por mucho tiempo es la posibilidad de escribir scripts contra Power Bi. Tal vez porque pensaba que NO ameritaba tanto para los medianos modelos con los que trabajo diariamente...

Visualize your data model's relationships in a simple and elegant manner.

A new method to create an automated data dictionary which also works for Power BI Premium models.