Power BI

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.

Just a joke. But it opens great data visualization possibilities. Everything (almost) is possible. You know the rules. Use arrows to move around the visual. … Read More

In this post I just wanted to show the ability to use the Delta Lake format that is very common now with Power BI. I will go over a quick example of creating the files to reference, building a view…

This step-by-step blog walks you through how to load large datasets in Power BI Desktop using parameters.

How to create a DAX measure to notify users filters have been applied to a report when there are hidden slicer or filter panels.

Writing Tabular Editor C# Scripts in Visual Studio has many benefits, on top of all Intellisense. This article walks through the configuration process.