Power BI

Learn how to automate the processing of tables/partitions which need to be processed in your model.

Using a script to create measures from a calculation group with correct format, for use cases where a base measure and a calculation group filter will not work.

There are several updates coming to email subscriptions that use full report attachments that we want to make you aware of, including extending the maximum length of reports to 50 pages, appearance in the Gen2 metrics app, and deprecation in the original version of Power BI Premium.

Power BI field parameters are a new feature in Power BI Desktop, and it's one of the best of the past months. In short, Power BI field parameters allow you to easily switch between dimensions attributes or measures in a filter. Previously, you had to do all sorts of DAX wizardry to make this happen,

If you want to: Present interesting Power BI discoveries to your colleagues Test your DAX Measures, reporting on a very clean Star schema Discover multiple DAX Functions Show different Power BI features by examples Then this Lazy DAX file is for you! It’s a Power BI Desktop file that you can freely download on my […]

Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop

How to use people analytics to improve workforce productivity, engagement and wellbeing. Make data-driven decisions in HR departments.

You might have seen the recent YouTube video by Guy in a Cube, where Adam explains how to work as an external user and publish content from Power BI Desktop to a B2B workspace. In this blog, I will…

In this blog post I show users how to document all their Power BI Row Level Security Roles & store the output in SharePoint

I noticed Adam Saxton post a tip on the Guy in a Cube YouTube channel about publishing reports from Power BI Desktop for external users. According to Microsoft Docs (as of June 21, 2022), you can&#…

Preview data is now available!

Show full category text on Y-axis of a bar chart in Power BI

Learn how to use Datamarts in Power BI. They enables you to store and explore your data in a relational and fully managed Azure SQL DB.

I was listening to Cole Nussbaumer Knaflic interviewing Steven Franconeri a few days ago (excellent episode!) and I was struck by something they mentioned towards the end regarding the illusion of being neutral when visualizing data. Many seem reticent to editorialize their data visualizations for fear of being perceived as biased. Cole was mentioning strategies she advocates for that bring more clarity and focus but necessarily leads to more direct steering of the reader’s attention from the visualization designer’s side (highlighting, annotations, simplification, etc.)

Many managers are uncomfortable with interpreting the numbers in their reports and dashboards. If this common data literacy problem isn't addressed across management levels, companies will continue to struggle in their efforts to develop data-driven cultures. In this article, I cover four key areas of data interpretation that are essential for all managers who are striving to make data-informed decisions.

In May 2022 Desktop update, we recieved the Field parameters function into Power BI. This function lets us change dimensions in visuals with a simple click on the slicer.

A good way to think of data visualization (data viz) is that it can be the difference between utter confusion and really grasping an issue.

Data visualization is the practice of translating information into a visual context, such as a map or graph, to make data easier for the…

Which specialists are required to build a BI-based system and what scope of work falls on each of their shoulders? — read about it in our…

Download (PDF): Guidelines for Measuring Trust in Organizations (updated 2013)IntroductionIn 2003, a coalition of organizations representing 50,000 public relations and communications professional

Speed to value, speed to audience

TL;DR, you can incremental refresh PowerBI using Parquet files stored in an Azure Storage without using any Database in the middle, you can download sample pbix here I am using this blog post by Gi…

If you’re using the new Parquet connector in Power BI there’s a chance you will run into the following error: Parameter.Error: Parquet.Document cannot be used with streamed binary value…

Was chatting with David Eldersveld and he suggested that he wants to run a competition using the famous New York Taxi Dataset with Datamart, long story short, I did endup publishing my attempt befo…

An article on the new catch keyword added to the Power Query language for the try catch statement

In today's data economy, the word 'insight' is used frequently in business. However, in many cases, it is misused without a clear understanding what the word means. We need to enhance insight literacy, which starts with developing a clearer definition of what insights really are.

According to a NewVantage Partners survey, 99% of firms have invested in data initiatives and 92% reported the pace of investment is accelerating. However, only 24% reported having a data-driven organization. This article looks at 10 reasons why your company may not have achieved this goal yet.

To become an effective data storyteller, you must shift your mindset from being reporting centered to embracing a different storytelling approach. In this article, I introduce the Insight Funnel and how reports/dashboards complement data stories. Then I explore the six key approach differences between reports/dashboards and data stories.

Forrester reports 74% of firms say they want to be “data-driven,” but only 29% are actually successful at connecting analytics to action. Actionable insights are the missing link for companies that want to drive business outcomes from their data. This article defines six key attributes that make insights truly actionable.