Power BI

We’ve just finished a difficult yet fulfilling 12th round for the Power BI Challenge, which was based on a transport and shipping dataset. This was probably one of the most difficult challenges we’ve had to date, and we’re very impressed with the participants’ in-depth analysis on their entries.    ...

PCF to enable an upload from excel functionality in canvas apps for Power Apps.Steps to push the component:You can push this component directly using the Visual studio developer command prompt. The …

Month by month I keep updating the Blog Portfolio of powerBImap.com: And each time I think this time we covered most of them, the next update will be a small

Recently Microsoft announced the Power BI integration with Jupyter, Now we can tell data stories using Jupyter notebook.As Microsoft launching new powerbiclient package we can export and embed Power …

The VS Code extension for portals adds the capability to configure portals using VS Code, and utilize the built-in Liquid language IntelliSense enabling help with code completion, assistance and hinting while customizing portals interface using VS Code

How to block users from opening contents from a site directly in the SharePoint interface while still allowing the access from Power Apps.

Premise In this post we’ll discuss how to temporarily prevent MS Power Automate from getting triggered. We will disable it for sometime and then resume the same without much of a hassle. The …

This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of [...]Read More »

Exam Ref DA-100: Analyzing Data with Microsoft Power BI is available now! Direct from Microsoft, this Exam Ref is the official study guide for Exam DA-100.

Wow – just wow. Thank YOU my dear readers for making my little blog page that huge ;-) More than happy I found out yesterday, that this page – is now featured in both – the BARC P…

According to the internet, a maxim is a succinct formulation of a fundamental principle, general truth, or rule of conduct.[1] Maxims tend to relate to common situations and topics that are underst…

Part of the the series: Doing Power BI the Right Way Later in this post, you will find a 27 minute framed video including a series of interviews and discussions with a few of my colleagues. Th…

Scenario:     In this scenario, the column [City] in my table has some dirty data with some space and case errors. It's also a mixture of abbreviations and full names of the cities. I want to find a way to unify the value of the column ‘City’ into the abbreviation of the cities, and merge this abbr...

We’re excited to bring you a new version of Power BI Report Server this month! With this update, we have a ton of enhancements, including a new field list, new and improved shape options, and several visual formatting features.

learn how to document your entire Power BI file in a few clicks, including all measures, codes, visualization, all for free and simple to do.

There are over 400 connectors to connect to Power Apps to almost every conceivable service, database or back end. This article is how to connect to end points that don’t have a custom connect…

Enterprise Service Management (ESM) Performance Dashboard built on Microsoft Power BI for the BMC Helix Remedyforce platform

There were several interesting Data & AI announcements that came out of Microsoft Build 2021. I put together this summary of 11 interesting and includes links to both the announcements and other follow-on information.

Learn how to export the data of a Power BI table in a few clicks. Any size, any table format, can be exported for free to a CSV file easily.

Learn how to write calculations in Power BI for comparing values of a month with the month before and get variance and percentage.

This post reviews the deployment of common changes to Power BI datasets and the implications for the availability of the affected objects for users and reports. BI teams and owners of PBI datasets …

A few months ago I heard about a new tool from Microsoft called Lobe which makes it easy to train machine learning models. It’s nothing to do with Power BI but I find anything to do with self…

Case I have a SQL server table with a varbinary field that I want to populate via a Power Apps form, but there seems to be no control for i...

This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. In a previous article we show

Source code files for Canvas PowerApps are a huge improvement from Microsoft. How can you do this from Visual Studio Code?

Back in December, we launched a new create experience within the Power BI service that allowed you to quick explore your data with just a few clicks. Now, we’re excited to announce, as our first integration of this experience, the launch of our Power BI integration within SharePoint lists. This experience empowers SharePoint list and Microsoft List users to easily explore their list data with just a few clicks.

Yesterday, I noticed John Liu and Brian Dang discuss Pieter's method. This method is referring tot my post of using a compose action inside an apply to each

Have you used the Parse JSON Action to generate Dynamic Content? Did you know that you can use it to validate json data?

The question is Variables or Compose actions in Power Automate?

When you create flows inside a solution you might have noticed these Environment Variables. What are they and what can you do with them?