Power BI

Deployment Pipelines within Power BI Service are a strategic feature that allows users to better manage content across the development stages of their organizations. By leveraging this powerful tool, users can simplify the deployment process and ensure security of potentially sensitive data. In this article, we’ll breakdown the specifics of deployment pipelines, and discuss how you can best leverage this tool within your organization for optimal efficiency.

For anyone who read the title of this and immediately thought, “Oh no, I can’t do C#! Since when do I need to be in app dev to do...

Naive Bayes is a statistical method of predicting the probability of an event occurring. This blog demonstrates the usage of Naive Bayes in Power BI

Make sure to download version 1.2.0 of #reportanalyzer which has just been released! Several UI enhancements have been made as well as adding the ability...

In this tutorial, interact with a Power BI dashboard that walks through how to do linear regression in Power BI.

In my quest to check out every last bit of obscure Power Query functionality, this week I looked into the ContextInfo option on the Sql.Database and Sql.Databases M functions. This option allows yo…

The newest generation of analysts is about to change the game.

Object-level security (OLS) enables you to restrict access to objects in Power BI, which includes tables and columns.

Learn how to get data of a Google Sheet loaded into Power BI using the Power Query Google Sheet connector with some details

In this blog post I show how to use tabular editor with Power BI premium per user or premium to quickly create partitions.

Need to configure Incremental Refresh but don’t have access to the Power BI Desktop file? No problem! Patrick shows you how to set things up with Tabular Editor.

We are announcing support for user impersonation using the EffectiveUserName connection-string property. This is truly exciting because it opens the door for mass migrations of tabular Analysis Services solutions that rely on EffectiveUserName-based impersonation to Power BI. It also opens new options for administrative tools and scripts to connect to datasets on Power BI Premium using different user identities! Impersonating another user can be as easy as specifying that user’s UPN on the connection string.

Power BI Desktop customers can now visualize data in their Delta Lake using Databricks with just a couple of clicks. In the past, connecting to Databricks from Power BI Desktop required the end user to perform a lot of manual configuration. Power BI Desktop integration with Databricks Partner Connect makes it simple to connect to your Delta Lake so you can start doing analytics and sharing insights with your business.

Capacity settings for datasets now in Power BI Premium Gen 2!

This blog post provides a close equivalent of the DAX's SWITCH function in Power Query, which addresses the SWITCH(TRUE... usage.

This series start discusses why Power BI Goals are a great fit for those new to Power BI and what three key decisions are needed.

Learn about the Universal Data Consolidator in this guest blog post by Sameer Bhide!

Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX that can be used in Power BI.

Learn how to use List.Generate in Power Query to loop through APIs. Repeat API calls until your condition is false. Works with pagination!

List.Generate is an advanced Power Query function that creates lists. It allows you to implement iterations and has similarities with loops.

Over the past few years I’ve blogged and presented extensively on the subject of Power Query’s data privacy settings (see here for a post with links to all this content). I thought I kn…

This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. When you execute a D

This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. When creatin

You can now create reports connected to Power BI datasets from a blank workbook in Excel for the web.

Action BI Toolkit provides tools to bring Power BI projects under source control, enabling professional development workflows and enhanced governance. Avail

In this blog post I show how to use Power BI to document all the measures in my Premium Per User/Premium datasets.