Power BI

When you use a measure as a filter in a Power BI visual, the DAX code generated might show a different behavior whether the measure is part of the values sh

Design your own Custom KPI Card in Power BI. Use these ideas to build your own professional looking reports.

Learn how to add targets to your KPI's for different countries by setting up the correct relationship in the modelling tab.

A reminder on best practices when working with Power Apps and external data sources.

I was chatting with the legendary George “The Enabler” Doubinski a while back, and he very rightly pointed out that a post I did a few years back on connector options involving Power BI Desktop, Dynamics 365 Customer Engagement and Common Data Service Microsoft Dataverse was…a little out of date. 😅 Two years, as it happens, is a lifetime in the Microsoft Business Applications space, and a lot has happened since the post went live.

In this Power Apps article I will show you how to use Power BI tiles to make interactive charts and show full Power BI reports inside an app.

Here’s a quick summary on how you can use Join operation in Power Automate!

Introduction: Microsoft recently introduced us to the Custom API feature which is a new way of creating custom actions in Dynamics 365 CRM as seen in our previous blog. However, while writing the previous blog, there wasn’t any way of using this custom API in workflows. But recently, we did see an

Introduction As seen in our previous blog, we can create a custom API that can be triggered in Dynamics 365 CRM Workflows. But since Microsoft is moving away from Dynamics 365 CRM Workflows to Power Automate Flows, we should too. So, in this blog, we will see how to use the same Custom API in a Pow

Variables can simplify your DAX code, help with debugging and help improve performance. To use variables in your DAX measure you need to declare a variable using the VAR keyword, give the variable a name, and then assign an expression to the variable. You can use multiple variables in a measure but when using variables […]

Using PowerBI Dataflow to share data between departments is increasingly getting more popular, with the rise of managed self service offering, it is not unusual to find a non centralised Data wareh…

My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the ori…

Introduction OK, so as I mentioned in Part 1, a user in my user group recently asked me about localizing a Power BI data model including table names, column names, measure names as well as titles for visualization, etc. I figured I'd break this subject up into chunks so there will at least be two pa...

One of the most challenging aspects of developing your own application is adding reporting capabilities. Power BI Embedded gives you the ability to include the capabilities of Power BI while hosting the reports in your application.  This post provides a curated resource guide.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - Power BI can become a closed garden for Excel users, but what if we use WorkFlows to expose the data?

Brand new External Tool to copy the Server and Port number directly from Power BI Desktop. Read the full article to get the new tool.

There are some cases that we want to add a leading zero to a digit, such as showing 01 instead of 1, 02 instead of 2 and so on. We have two options to do this in Power BI, doing it in Power Query or doing it with DAX. Adding a Leading Zero in Power … Continue reading Quick Tips: Adding Leading Zero to Integer Values (Padding) with DAX and Power Query

Learn how to create a report of column's value distribution in Power BI report using Power Query techniques and enhance data profiling.

It can be challenging to pick the right data type. You may start with a text field to store your email addresses and then later realize there is an Email type.  Maybe you picked DateTime when really you only needed Date. A new API has been made public that will allow users to change the format of a Text, Integer, or DateTime data type to any of the compatible formats for the type.

In this Power Apps tutorial, We will discuss what is container control in PowerApps and how to use PowerApps container control in your app. Also, We will cover these below topics:PowerApps container …

Our upcoming State and Local Power BI Community Call will focus on administrative scripts that can be used for lightweight management of your Power BI environment. This will be a script heavy session …

Teachjing's Desktop

We are happy to announce that we have 15 new Independent Publisher connectors that were published in July and August.

Usage scenarios: Sample data table:   #1. Check field if they existed English characters.(upper: 65 ~ 90, lower: 97 ~ 122)   Create a list of all English characters. List.Transform(List.Union({{65..90},{97..122}}),each Character.FromNumber(_))​ Add a custom column with function to compare each cha...

Standard Bank, which operates in more than 20 countries in sub-Saharan Africa and abroad, adopted a self-service Power BI model in 2017 and has evolved the platform from descriptive analytics to predictive and prescriptive models. The bank’s Insurance Business group collaborated with its BI Data Visualization team to use AI and automated machine learning to predict and accurately target customers.

Issues and new features in this release: https://github.com/microsoft/coe-starter-kit/milestone/14 First Time Setup Instructions Get started with the CoE Starter Kit Setup: https://docs.microsoft.c...

I’m happy to update that during September we are modifying the preview release, specifically lifting the 50 exports per hour per capacity limit. More details inside.

JSON array to collection in Power Apps canvas app, Bind JSON array to a gallery in canvas app

add/ remove property to a JSON object dynamically in Power Automate, update property in a JSON object dynamically in Power Automate

Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Data Integration in Power Platform Admin centre – One of the few and detailed post on this topic. Wonderful read.