Power BI

ALM Toolkit is one of those must have tools for PowerBI. Learn about this tool from Christian Wade and how the ALM Toolkit aids your Power BI Development.

<p>Today, I’m excited to introduce the lineage view GA and new advanced experiences within the lineage view.<br /> Check it out!</p>

<p>To encourage the use of standardized dataflows, Power BI now provides two ways you can increase the visibility of your valuable, high-quality dataflows: promotion and certification.</p>

This is a documentation of hidden but essential microsoft power query keyboard shortcuts, for power bi, that is meant to make operations less tedious.

Time series forecasting in PowerBI. (An Almost) Comprehensive Guide

Today I discovered a way to easily copy all queries (including the groups) from a PBIX file to Excel without entering the power query editor in Excel. In my case I needed to copy the data returned …

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various &#…

I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to add measures by copy and...

How Rockwell Automation drives a data culture using Power BI and Azure

Announcing – Copy a Visual as an Image in Power BI Service

April release of gateways.

<p>Today, I’m excited to introduce the new look of workspaces in the Power BI service. Check it out!</p>

Imagine that you are building a Power BI dataset for corporate reporting, that will also be reused for self-service purposes by many others. It is up to you, as dataset author, to make it as simple…

One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the table It can occur with almos…

Want to download files from webpages with Power Query to regularly refresh in Power BI? See how to find their URL and tweak their parameters to your needs:

PowerShell 7.0 was made generally available last month and one of it’s new features is pipeline parallelization for the ForEach-Object cmdlet. Scripts running on PowerShell 7 or higher can si…

Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from "Reza Rad", if I want to get the…

In this post series, I am going to show how to use new Q&A visuals for the aim of creating easy visuals by typing the natural language and define some user-defined terms and how to manage it. This visual is now generally available for everyone. IN this post some introduction to this visual about how…

Power BI is taking off, and it’s fast becoming the most popular business intelligence platform on the market. It’s easy to engage with and get professional results quickly, making it the perfect tool for organisations looking to beef up their BI prowess and make data driven decisions through-out the organisation. In this post we’re going … Continue reading Power BI Governance, Good Practices, Part 1: Multiple Environments, Data Source Certification and Documentation

<p>It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of February and March.</p>

In my last tutorial here, you learned how to import COVID-19 confirmed and death cases from Johns Hopkins dataset to build your own Power BI dashboard using Power Query. In this tutorial, we will go quickly through the DAX measures that will help you gain better analytics capabilities using Power BI time intelligence. To follow …

In the Power BI community, had the idea of providing Power BI COVID-19 dashboards as screensaver. After a brief research, the following blog post was created. In order to be able to display web pages as screensavers on Windows 7 or newer, I use the Web-Page-Screensaver from Cameron Currie. The corr...

This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020.

I have a Power Query script that I usually use in any Power BI solution that needs time-based analysis. However, I never had a chance to publish it here for everyone to use. So here it is. A friend's question about a time table reminded me that it is good to publish this to the…

Tutorial: Create a decomposition tree visualization in Power BI

This blog post shows how you can safely transform column types in Power Query, accounting for columns that can possibly be missing.

Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters,…