Power BI

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.

We’ve heard your feedback and would like to introduce you to the redesigned format pane! In this blog post you’ll find the biggest changes we’ve made to improve the usability and consistency across visuals and non-visual elements.

I was shocked, suddenly important reports were missing from my workspace in Power BI service. But thanks to the help of Mellisa Coates, I was able to make

Download the cheatsheet that will help you fine tune your Power BI reports!

A while back, I was working on a project involving getting data from Excel files. The Excel files contain the data in sheets and tables. Getting the data from the tables is easy. However, the data in the sheets have some commentaries on top of the sheet, then the column names and then the data … Continue reading Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online