Power BI

This blog post will show you the different tools and interfaces I use to pick apart Power Apps Portals and Power Pages templates.

This blog post will introduce you to the different Power Pages Templates in Power Platform

Power Apps PATCH function is the hardest function to understand. That's why I built a no-nonsense cheat sheet to help you figure it out.

The new preview feature “Field parameters” in Power BI desktop has opened a lot of creativity in the Power BI community. But if you use a connection to a Power BI dataset or Azure Analy…

The most exciting (at least for me) feature in the new Enhanced Refresh API (blog announcement | docs) is the ability to cancel a dataset refresh that’s currently in progress. Up until now, a…

What is Field Parameters? Power BI service in May 2022 released the Field Parameters feature. As explained in the Microsoft site... "Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and cus...

Scenario: The May 2022 version of Power BI Desktop includes a very interesting and useful feature – Field Parameters. To better help you understand this new function, I would like to generally introduce it and share with you about some common application scenarios.   Introduction Field: a table colu...

If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calc

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.

You can save a lot of time using templates when creating new Microsoft Lists. List templates, both ready-made ones and your own custom templates, help keep your information tracking consistent - being able to reuse templates to uniformly create a common set of columns, formatting, views, rules, and ...

<p>The Power Pages design studio is designed for low-code makers to rapidly build and style data centric business sites.  It offers an intuitive WYSIWYG (what-you-see-is-what-you-get) authoring experience that makes it easy for any maker to build and style a site with minimum design and coding skills.  Let’s look at some of the new experiences that…</p>

We will soon be supporting a new URL for Power Automate: make.powerautomate.com. Read to learn about the change and troubleshoot access issues if you may encounter.

The Dataverse Service Client SDK is now Generally Available for developers to use

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.