Power BI

In my last two posts (see here and here) I showed you how you can call the new endpoints in the Power BI REST API for exporting a report. There are some obvious, extremely useful applications for t…

See how your peers are creating data-driven businesses, breaking down data silos, reducing costs, and improving results using Azure Synapse Analytics and Microsoft Power BI

Today we are excited to announce that you can now draw fields that were not automatically detected by AI Builder, available in preview.

The Center of Excellence (CoE) Starter Kit is a set of templates that are designed to help get started with developing a strategy for adopting, maintaining and supporting the Power Platform, with a focus on Power Apps and Power Automate. A core part of the CoE Starter Kit is a Power BI Dashboard that provides you with a holistic view with visualizations and insights into resources in your tenant: environments, apps, flows, connectors, connection references, makers and audit logs. In this post, discover what’s new and what you can learn from the dashboard.

My family is a foster family for cats and kittens from the cat shelter where we’ve adopted some of our own cats. Usually a litter will stay with us for a month or two, but it depends on the k…

To build something like this in Power Bi, we don’t need any custom visuals or excessive coding experience. Just a little bit of thinking out of the box :) In Range Bar Charts, data points are built starting from the minimum values per category.

You have lost your column types in Power Query and want to get them back? Check how easy it is to automatically detect and change all column types at once.

Link previews for Power BI in Microsoft Teams are now available as a preview features. They help users collaborate by making it easier to find, open, and stay up to date when sending links through Microsoft Teams.

Currently I am working with a project where we extract data from a SQL server – some of the business logic is built into scalar value functions (documentation). Now the magic of PowerQuery enables …

Have you ever wished you could change multiple Power Query load destinations at once? Well now you can with Monkey Tools!

What is Progressive Disclosure? Progressive disclosure is an interaction design pattern that sequences information and actions across several screens (e.g., a step-by-step signup flow). The purpose is to lower the…

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

If you have ever wanted to refresh selected or multiple tables in Power BI desktop, but not ALL the tables this blog post explains how to achieve this.

Cerner Corporation implements a single source of truth for data

We’re pleased to announce the first Monkey Tools update is now available! A new feature, some new logic and an update to our Power BI connector.

We are working hard at Enterprise DNA to build a number of tools that can assist Power BI users in their development work. Today we are excited to announce the release of our DAX Clean Up Tool Why a new tool to format DAX formulas? One of the biggest hurdles that any Power BI user faces when they start developing reports and dashboards is attempting to understand how DAX formulas and DAX code work. WeContinue reading

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

BeComments - Add your comments to your Microsoft Power BI report and link it with your data! Add formatted text, images and even videos!

Recursive functions in Power Query are not very popular, but sometimes very helpful when in need. In this post, I'll explain what a recursive function is, how it works, and explain it through a famous recursive example of Fibonacci Sequence. Fibonacci Sequence Fibonacci sequence is one of the fundamental recursive operations in math, below are…

This blog post demonstrates the how to steps to create calculation groups which can be used to display multiple measures and format strings in Power BI

Dynamically retaining only columns that contain Actual values from a Table This article is part 3 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain […]

In this post, i will show how to use Patch function in PowerApps to update multiple records in SharePoint list as data source. Hope it is helpful. Introduction Patch function is used to modify a re…

I need to patch or insert certain fields for every record in a collection, into a datasource. Meaning, FOR all records in my collection, insert an individual record with certain fields into some datasource. Her is my collection: coll.FieldA, coll.FieldB, coll.FieldC I need to do a ForAll(coll, p...

I came across this Formula in the UX Patterns: Multiselect Blog ForAll(Filter(Gallery1.AllItems,Checkbox1.Value = true), Patch( ProfileSkillSets, Defaults(ProfileSkillSets) ,{ ProfileID:EditForm1.LastSubmit.ID, SkillsetID:ID, Skillset:Title })) This works great when adding new Records, however I...