Power BI

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 …

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.

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…

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

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.

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.

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 …

If you want to show the ranking in a Power BI visual, one way is to use a visual that supports that, such as a Ribbon chart. Another way, which is a more common way, is to write a calculation for rank, and RANKX is a DAX function that can help you with that. In Read more about Showing Ranking in a Visual in Power BI using RANKX DAX function[…]

Microsoft Excel is one of the most common data sources for Power BI. We can store Excel files in various storage types. The way we get data from Excel varies depending on the storage type. In this post, I quickly show two methods to connect to an Excel file stored in SharePoint Online. Method 1: … Continue reading Quick Tips: Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop

Looking for ANOMALIES in Power BI? Justyna Lucznik walks Patrick through the new anomaly detection in Power BI and gives a SNEAK PEAK at what’s coming! Anomaly detection: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-anomaly-detection

Learn how a Center of Excellence helped Microsoft create a standardized analytics and data platform to unlock insights with the right operating model, stakeholder engagement, and shared and dedicated investments.

Log Analytics is a basic tool for the entire Azure environment, I wrote about it before.The possibility to access log analytics data from a tool for analysis, such as Power BI, only increases its …

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection

Join the Power BI team and be inspired by presentations, learn best practices, and discover helpful resources with other attendees. Join your DEV community for live discussions on camera, and in chat …

Scenario: In Power BI Desktop, when we connect to a .json file, power query editor will transform it automatically if its structure is single. Sample data1: Output in power query: From the APPLIED STEPS we can find that power query editor expands all columns automatically to get this result table....

Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your data models. A conditional expression in DAX – like an IF function – can be evaluated in two ways: eager and strict. Understanding the difference be

My favourite Power BI announcement at the Microsoft Business Applications Summit was, without a doubt, that Excel PivotTables connected to Power BI datasets will very soon work in the browser and n…