Power BI

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!

In this Power Apps tutorial I will show you how to make a multipage form on a single screen. It is not necessary to create multiple screens to do this.

This tutorial will show you how to create a pop-up menu in Power Apps two different ways: a pop-up form for data entry and another to confirm deletions.

I've created a top 10 list of the most useful and unexpected tips & tricks to help you become a master at building Power Apps forms.

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.

In Canvas Power Apps, the makers don’t really encounter anything that suggests traditional application development. Apps are not treated like a pile of code, but more like a single PowerPoint …

When you develop responsive apps in containers become very important. In this post I’m trying to help with the common challenges.Horizontal vs Vertical containersTable of ContentsA while back I wrote …

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.

Which method is better for Power BI? Formal vs Self-Training. Will one accelerate your skill faster?

If you’ve visited the Tab order area of the Selection Pane in Power BI in the last couple of months, you might have noticed some new buttons. Three new buttons for managing tab order in Power…

Work together to meet challenges effectively with Microsoft Power Platform—analyze data, build solutions, automate processes, and create virtual agents.

This was a huge week for Power Apps at Ignite and we want to thank everyone for joining us and continuing to engage in the community. This post includes a round up of the announcements for Power Apps at Ignite.

Check out the new enhancements to AI Builder we announced at Microsoft Ignite to help bring AI into your Power Platform solutions.

Welcome to the November 2021 update. The team has been hard at work delivering mighty features before the year ends and we are thrilled to release new format pane preview feature, page and bookmark navigators, new text box formatting options, pie, and donut chart rotation. There is more to explore, please continue to read on.

We’re excited to announce enhancements to the export to Excel experience. Read this blog to learn how these changes help more Excel users use data from Power BI to make decisions.