Power BI

Come together and discover the latest innovations in code and application development—and gain insights from peers and experts from around the world.

How to configure a service principal in Azure and then use it in Power BI Admin REST API calls in Power Automate for authorization

One of the powerful features of the Tabular data model is to extend the model by adding calculated columns and measures. Both objects are defined using DAX, but besides this similarity, they are entirely different beasts. Here you will find guidance when to use what!

Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? In the 1st part of the series, meet VertiPaq - "brain & muscles" behind Power BI!

In the 2nd part of "Brain & Muscles" behind Power BI series, learn about data compression and how VertiPaq chooses the right algorithm to make your data model optimal

Learn the various parts of an MSBuild project file, including items, item metadata, properties, targets, and tasks.

In this article I will show you how to add a blank value to a dropdown list in Power Apps and get dropdown list values from SharePoint.

I was looking at the output of Power Query’s Query Diagnostics feature recently (again) and trying to understand it better. One of the more confusing aspects of it is the way that the Power Q…

Learn how Power BI prototyping and sharing is about rapid exploration of user requirements.

Note: new version has been released, read more here or download from GitHubIf you created Web API queries against CRM/Dynamics 365/Dataverse probably you are familiar with CRM REST Builder. The …

Learn how Power BI advanced data model management is about empowering creators with advanced data modeling and publishing capabilities.

Learn how Power BI advanced data preparation is about improving the reach and reusability of dataflows.

It is not common to face rounding differences in Power BI. However, when it happens, users are usually disappointed and surprised. In one of the last classr

A useful way to think more holistically about how data visualization works

Adobe Illustrator has been a tool in my dashboard design kit for quite a while. I’ve used it predominately for creating report assets such as icons, headers and backgrounds. I’ve also used it to create SVG visual elements such as the dice, turbine and scatter plot shapes and markers pictured below. But there’s another way… Continue reading Power BI + Adobe = Magic

Comparative Analysis by different values in same dimension in Power BI Have you ever wanted to compare metrics between 2 sets of selected values in the same dimension in a Power BI report? For example, let’s say you wanted to compare claims metrics of one hospital or a group of hospitals to another ...

I had a business requirement where I needed to create a P&L report that included RLS by business leaders for each department. A leader…

I’m assuming You have figured out how to google a few skills and create a few PBI reports that refresh on their own without five people on…

In recent Microsoft releases many new features have been introduced. In this blog we will see how to use Power BI quick report (preview) on the view page in a model-driven app, to visualize CRM …

I am happy to announce a new Out of the Box virtual table for Dataverse, AAD User. AAD User makes it easy to retrieve any user that is in your organization’s Azure Active Directory as well as user details like job title, email, phone number and more.

Solve your SQL Server SQL Azure issues with these valuable tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

In this article we look at how to call Logic App synchronously from Azure Data Factory.

Sometimes in life you have to do things you really don't like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData source component for this task, as described in one of my most popular articles ever: Reading SharePoint Lists with Integration Services 2017 (I'm not

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them. Partitions in tabular models https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

Exchange Rate table is one of the most important tables in the sales module, however, to update the values in this table the users have to perform this action manually, in most cases users would like to keep this table updated on a daily basis. In this post I will try to explain in detail how to use Power Automate to create your Custom Connector and how to use this connector to update the exchange rates automatically. Part 1 : Create a Custom Connector In this post we will be using the https://c

In this post I will show you how to convert an array of objects to a comma separated string using Power Automate.

Application Lifecycle Management is a challenge. My approach is fully automated, made for Citizen Developers and based on Dataverse...

Runtime localization support for Code Components on Custom pages and Canvas apps