Power BI

Do you have the following requirements? You want to pass an array from a Canvas App to a Power Automate You want to pass an array from Model Driven apps to Power Automate. You have to parse JSON data in your canvas app and perform further processing. If your requirement is similar to this, this … How to pass an array from PowerApps to Power Automate Read More »

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This one is a really cool requirement I came across today. I had this requirement, I implemented it and I can’t wait to share it with my readers. So what am I going to cover here? In this blog I am going to cover the … How to download Notes from Power Apps Canvas Apps? Read More »

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This blog is again quite simple one and yet quite interesting. In this blog I will discuss about how we can set a variable inside For loop in canvas app. You might be wondering – “Isn’t UpdateContext and Set function already there in PowerApps to … How to set a variable inside ForAll in PowerApps Canvas apps Read More »

get created record id using patch in canvas apps, get created record details using Patch in canvas apps

When you want to leave it up to the user what device they use, responsive designs in Power Apps becomes important.

In this blog post, I will show you a trick that you can follow to create a good user experience for your end users in a Canvas App by auto-incrementing the height of controls that do not support "Auto Height" property. This will enable Power Platform Developers to enhance the intuitiveness of the application built on Canvas Apps.

With this public preview, notifications can be send to users within the model-driven app and are displayed using a notification center and notification toasts.

In this article I will show you how to display a user photo in Power Apps or the user's initials in a colored circle when a photo is unavailable

With the app side panes public preview, developers can more than one pane on the right/far side of the model-driven app.

Microsoft Power Platform is releasing new capabilities in Public Preview that allow for greater control and customization of your Power Platform data loss prevention (DLP) policies.

When a new environment is needed as a workspace to develop a Power Platform project – and non-admins are restricted from creating environments – admins must provision the environment for such projects to facilitate development that will ultimately help the company achieve its goals. While restricting environment creation provides valuable security advantages, admins can easily become the bottleneck for project movement if there is no automation in place and the demand for new environments is high. Depending on the company, more configurations might be required to define a ‘secure’ environment. The Environment Request components in the CoE Starter Kit are designed to help simplify and automate the administration of Power Platform environments.

How to create Microsoft Planner plans using Power Automate flows without using a custom connector.

With the free QuickChart API we can extend Power Apps to use over 20 different chart types have and more options for their appearance.

Earlier this week I did a live stream event.  I put out a poll and asked people to tell me what topic they wanted me to talk about.  The options were Calculated Columns vs Measures Tips for Excel users moving to Power BI Using Variables in your DAX The overwhelming [...]Read More »

Have you ever wanted to send only some of the attachments on your record via email to someone? The solution is actually quite straightforward, but

It seems like a couple of times a week I get a panicked message from a customer who saw the dreaded alert: “Your organization (tenant) is over capacity” in the Power Platform Admin Center....

Here is how to create a Power BI chart with an accented gap between two lines. It will help you evaluate the difference between two values.

Find out which visuals in your Power BI report generated a given DAX query

Sample Table In the following scenario, I would like to insert a sum row for each 5 days as an example.   Method 1      let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdBLCsAgDATQu7iWkon1dxbx/tdoAqWQjrh7yiTjWklFcdlJOUEk7fyRGtUgxaQHuU1GkGrSgjR60yl5+HgEmhRk9/8k+N4z...

When you are new to use the relative time filter and relative time slicer in a report, you might find that the filtered records are not consistent with that you observe the results manually. For example, I have some ticket data as below. I hope to see the records created in the last 12 hours of the ...

I created a video to demonstrate how you can highlight any time-bound events on a chart timeline using DAX and conditional formatting in Power BI.  In addition, in this example, we will analyze and visualize how events like Covid lockdown, promotions, and campaigns can impact sales performance. You ...

Today we are happy to announce public preview of default label policies in Power BI Desktop and call out significant features that address top asks for Power BI information protection released in the last few weeks.

Learn how to secure report pages or tabs in Power BI from unauthorized access and control who has access to what page.

A very common requirement for a Power BI report that I stumble across at almost all of my customers is to automatically show data for the current day/month/year when a report is opened. At first sight this seems like a very trivial problem but once you dig into the problem, you will realize that all…

In the last two posts, I have explained how to access Azure Map and create bubble charts and Bar charts with other available settings. check the first Post from here and the second one from here. In this blog, I am going to talk about different layers we can have on top of the map. Read more about Azure Map in Power BI with Layers: Part Three[…]

In the last post, an introduction to Azure Map was presented. Azure Map has considerations and limitations as below( that may resolve later as now is in preview) You can use it in Power BI Desktop, Power BI Service, and mobile application But, not available Power BI publish to the web, Embedded and service embedding. Read more about Azure Map in Power BI: Part Two[…]

Learn about using Azure map for visualization in a Power BI report and options available for this geolocation service.