Power BI

Many gauge visuals take-up a significant amount of screen real estate, and I wondered if Deneb/Vega-Lite could be used to minimize the required space. Here’s what I came up with: This example uses a number of optional Deneb/Vega-Lite components, including: a title block c/w subtitle a transform block to extend the dataset a layer block with 4 specifications as follows: a bar mark for 100% width background (target) a bar mark for progress width = actual/target; percent) (actual) color = gr...

At the heart of growth is a community, a place for people to collaborate, share ideas and discover new ways to apply technology to achieve more.

In this blog post you will learn how to export your Dataverse Data to an Azure SQL using Data Lake and Azure Data Factory.

Way back in 2019, I was fortunate enough to meet Jeffrey Wang while at the MVP summit in Seattle. Jeffrey is one of the fathers of the DAX language and as such he is a hero of mine. I sat through some presentations and discussions, and Jeffrey mentioned an idea [...]Read More »

After working a lot with buttons one begins to notice certain specific details. In this case we are going to talk about the navigation between pages and format of a button. For those who didn't know, Power Bi allows us to use measurements as functions in different format options. Among them we will ...

New September Release Power BI Report Server 2022

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this artic

In a previous entry I explained at length the various ways to secure data in business intelligence products. In this follow-up I want to elaborate on which method(s) to use for what purposes. RLS vs. OLS vs. DDM Row Level Security (RLS) is meant to restrict the depth of what any specific user or group

In this article, we explore Power BI App Audiences and why they are such a powerful feature for managing and using content in Power BI Apps.

This article describes how to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date.

Create Power BI Metrics (goals) scorecards

The Creator Kit for Power Apps is a toolkit developed by Microsoft’s Power CAT team and the community. It helps you “easily create consistent, beautiful, and effective user experiences for custom business applications”. All controls are built on the FluentUI framework that is used throughout Microsoft applications, so using these controls means your app will have a beautiful, native Microsoft user experience. In this post, we will look at how … Continue reading Getting Started with the Creator Kit for Power Apps

The Microsoft Creator Kit provides a nice details list control based on Fluent UI. In this post, we will look at how to pass context to a custom page and display records using the details list for Power Apps. We will go through an example of showing related contacts of an account record in a side pane. First, let’s create a new custom page. We will edit the Sales Hub app … Continue reading Fluent UI Details List with Context in Custom Page

Ways we can get to the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI

Learn the difference between DirectQuery mode and Live connections in Power BI

Share the article

Recently a new ParseJSON feature was added to Power Apps. ParseJSON is possibly one of the most complex functions available in Power Apps. in this post some

With the release of Dependent Assemblies (preview) we can now use 3rd party libraries directly within plugins without the need for questionable ILMerge hacks. Lets use this to expand on the previous blog, Using Power Fx in Cloud Flows, so that we can more simply use Power Fx within a cloud flow.

This is about the monthly releases that happens for Pro-developer tooling

How to use the new experimental PDF Power Fx formula in Power Apps to export a gallery as PDF and email it directly from Power Apps.

How to use the new ParseJSON option in combination with Power Automate to send requests to the Graph API and parse them back in the app, in a generic way.

Write comments to describe the intended goal of a section of Power Apps code. Code with comments takes less time for others to understand.

Power Apps new ParseJSON function converts a text string into a record or table. It can also be used to return a collection from a flow.

This new capability allows cloud flow authors to efficiently identify and troubleshoot flows by being able to view flow’s trigger details in Flow Runs view.

Welcome to the September 2022 update. We are excited to announce the release of Check Performance for Excel web users to help speed up your workbooks and modern comments for Windows users to allow for a more streamlined commenting experience across products. For Insiders using Mac, you can now shape...

In this post, we will look at how to implement Custom Tracing in Monitor and App Insights with Power Fx. First, let’s create a new Custom Page, and add a button to the page with the label “Run Trace”: The syntax for the trace function from the Microsoft documentation is: Let’s add the following Trace statement to the OnSelect of the button. Note the 3rd parameter is an object where … Continue reading Custom Tracing in Monitor and App Insights with Power Fx

In a previous post, we looked at how to install and use the Power Apps Creator Kit to create beautiful and consistent user experiences in Power Apps. In this post, we will look at how to use the Fluent Theme Designer in the Power Apps Creator Kit to create themes for your apps. Let’s start with the Canvas Reference Apps. There are 3 apps – canvas template, canvas kit reference … Continue reading Creating Themes with the Power Apps Creator Kit

Earlier this year in March, as part of the 2022 Release Wave 1, Microsoft introduced the Modern Advanced find to replaced what we have known as Advanced find for the past 20 years or so. It was definitely time to modernize this, but there were a few shortcomings to this new release which caused many customers to hold off and wait until the missing functionality has been developed and made available to customers.