Power BI

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?

Last month I wrote the first part of this blog post, which is intended for users that are in the beginning of their Power BI journey. After a long wait, I finally had some time to finish the second part of the post! If you don't remember what we discussed in the first post, have a look in the link below: Power BI Report Development 101 - Part 1 (datapears.com) Review of the Part 1 finished? Amazing!! So, let's go back to our diagram: Colours legend: Blue Squares - These steps are usually mandato

We’ve started to roll-out an update to the home experience in the Power BI app for Microsoft Teams. Users in Teams will see a new “In Teams” pivot on Power BI home that makes it easy to find Power BI tabs you’ve visited previously in Teams channels. Read the blog to learn all about it.

Develop your Power Apps and Power Automate skills with the Power Apps Developer Plan and get a free environment to build, test, and distribute apps.

At its Build developers conference, Microsoft unveiled its first features in a customer product powered by GPT-3, the powerful natural language model developed by OpenAI, which will help users build …

I'm going to start this post by saying that it will be a bit different from the posts I've written before. Today, I will be sharing with you my ideas around core Power BI skills, and how I see them …