Power BI

Learn how to create a dynamic date table in Power Query. Make sure to pick up your free script to generate a reusable calendar.

You may already be aware (but then again, maybe not) that Microsoft shares its plans for upcoming new features for the Power Platform every 6 months, and Power BI forms a subset of that plan. The next plan is called Power Platform Release Plan 2021 Wave 2. It takes a [...]Read More »

Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with no item…

A productivity tool for analyzing a Power BI report's performance.

Let’s say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory – Ok this is easy enough. We …

We are excited to announce that XMLA endpoints on Premium Per User (PPU) now support Azure Active Directory (AAD) authentication with service principals. This authentication option enables administrative applications to perform automated maintenance tasks and unattended service-level operations by using their own app identities, which is often a requirement for migration of existing tabular data models from Azure Analysis Services and SQL Server Analysis Services to Power BI Premium. For technical details, see the article Automate Premium workspace and dataset tasks with service principals in the product documentation.

Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each storage mode is and when you would use it. Picking the correct storage mode for each table in your model … Continue reading Power BI Storage Modes for Aggregations

Improving Power BI reports’ performance is not always easy and straight. Although Power BI Desktop provides “Performance Analyzer”, the details given are not as rich as they could or should. “Power…

In this article we perform a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and

We are thrilled to announce some exciting new capabilities for streaming dataflows in Power BI.

Welcome to the October 2021 update. Leaves fall, Power BI calls; and we are excited to release additional functionality and performance improvements for DirectQuery, optimization for the SWITCH function,  and new Bitwise DAX functions.

Video by: Reid Havens Learn how to add [DAX] measure driven values the y-axis constant lines . Allow us to essentially recreate multiple analytics lines that can be configurable by user slicer selections in Power BI. RELATED CONTENT 🔗 Positive/Negative Line Colors

As mentioned in the June and July feature summaries, we are switching a vital component of Power BI from CefSharp to WebView2. We’re making this switch to better optimize our development and release process (which means we’ll be able to spend more time developing new features!). It also means that you’ll automatically get the latest security patches as the WebView2 team ships them instead of waiting for us to update Power BI Desktop. Please continue reading as we have some important announcements to make and recommended actions for you to take.

If you are looking to grant users in Power BI Read permissions to a dataset, I show you how I did this in my blog post.

This might be the first (and possibly only) time in a very long while that I got really excited about a custom visual for Power BI. Yes, I use custom visuals every now and then, but generally speak…

October 2021 is mapping month over at Workout Wednesday for Power BI. As part of our challenges, we build a sample report and use the Publish to Web functionality to share it on the website. While …

We talk about optimizations a LOT! We pile onto a question posed by Chris Webb – Should you optimize for CPU in Power BI? We think the answer is YES! Let’s explain… Chris Webb’s Blog: https://blog.crossjoin.co.uk/2021/09/19/why-you-should-optimise-your-power-bi-premium-reports-and-refreshes-for-cpu-time-as-well-as-duration/ 3 signs it’s time to OPTIMIZE your Power BI report https://www.youtube.com/watch?v=uKSkMDEGM2I

DAX is simple, but it is not easy. Watch the video to learn why, and remember: Practice. The. Fundamentals.

This is an updated version of the presentation I did earlier in the year which I recently presented for the Minnesota Data Saturday 13 event this past weekend. Here is the direct link to the presen…

Encoding and decoding strings with zero-width characters seems a topic out of a spy movie, but it can be achieved with power bi.

We have all been in a situation where you want to get more insights in the specific settings for a published dataset. But when this dataset is owned and published by someone else, you have to take-…

Using professional looking Buttons in Power BI elevates your report to be visually appealing and functional. Learn how here.

There are four ways to think about scope when planning for workspaces in the Power BI Service: (1) What is the content? (2) Who’s the content delivered to? (3) How will the content be managed and by whom? (4) How will the content be deployed? This post covers this one aspect of workspace planning an

I recently came across a real head-scratcher of a question on Stack Overflow. This post is an expansion of the answer I gave there. The goal is to provide a useful model to understand filter context. This is foundational knowledge for any aspiring DAXter (DAXist?) and is required to understand CALCULATE properly.

We are pleased to announce the preview availability of our new Unused Artifacts API. The initial version of this API returns a list of datasets that have not been used within 30 days for a specified workspace, and successive revisions will include other artifact types such as reports and dashboards.

This blog post details how to extract data from the Power BI Service dataset using PowerShell to extract the data.

Example demonstration creating a hills and valley chart, area between two lines in Deneb Custom Visual, Vega-Lite for Power BI.

In my short career doing data visualization with Power BI, I have always desired the flexibility to do more with my visuals. So when I came across a demo for Deneb in a meetup last year, I practically lost my head. And when I finally got my hands on the visual I was not disappointed.… Continue reading Exploring Deneb for Power BI