Power BI

Reading Time: 5 minutes One of the newer features in the Power BI Admin Portal is the ability to view all of a tenant’s Workspaces. As I was browsing through the collection of workspaces, I noticed several marked as Orphaned. What is an orphaned workspace, and how does it occur? What is an Orphan? An orphaned workspace is one that…

This blog builds on my previous blog, Keeping Big Data Big with Aggregations. The below video contains an end to end demonstration of setting up in-memory Vertipaq aggregations over data stored in …

how to find the tenant in Power BI.

Data Modelling! YES - That's the most important thing to learn when using Power BI and here's an article on why you should care about it.

Reading Time: 1 minute Charticulator is the first item that I mention in my recent Power BI Best of 2018 in Data Visualization post. It’s an exciting new tool from Microsoft Research to quickly build …

If you have used the drill down/up feature in Power BI, you know that it is a very powerful feature for exploring the data, you can expand a hierarchy to the next level, and go back. However, there is…

Workspace version 2 has been available in Power BI Service for more than 6 months now. The new version introduced in August 2018, however, still many people don’t know what it is, and what is the diff…

I have found that at times people get other Power BI reports and are not sure what data sources there are in the file. As well as which data sources are connecting to what? In this blog post below, I …

<p>The team has been busy the last month shipping new features and fixes for you. You can view the weekly release information here https://aka.ms/PAWeeklyReleaseNotes . Che…

<p>You’ve been through this before: you create a useful group of controls like a header. Then you copy and paste it on each screen of your app where it&#8217;s needed. But if you w…

In 2006 I applied to work at Microsoft, in their Dublin, Ireland office. I was offered a job and moved immediately to Ireland from Finland. On my first day I was handed a respectable pile of paper by

Using DirectQuery in Power BI? Things slowing down and you want to make interactions snappier? Patrick looks how you can change a few settings to take the experience within Power BI to the next level!

Microsoft® PowerApps & Flow are the Microsoft replacement to InfoPath & SharePoint Designer. Okay, that is a bit unfair to PowerApps & Flow, as both products address everything that users disliked abo…

In my Power BI courses I always recommend some books and sites that will help them learn DAX or M. Most of the time i'm presenting to new users to Power BI, and having to get them to move from the Exc…

Back in October, we announced that several new capabilities would be coming to Power BI for e-mail subscriptions. Today, we’re thrilled to announce that one of the most requested subscription featu…

The following steps show how to create a new column in a table using existing custom function code. Applicable to Power BI and Power Query in Excel.

Office365 family provides a lot of services for you and your organization. In recent weeks I was playing \ working with some of them like Power BI and MS Flow. I wrote an article about sharepoint.stackexchange analysis with Power BI. Power BI is a gr... [Click to read more]

When a new response is submitted, start an approval process. If approved, record the response as a new item in a SharePoint list.

I was working on a larger Power BI report and there were quite a lot of tables, where the text size needed to be changed. Using the new search box feature in the Formatting options I searched for T…

<p>It&#8217;s now possible to distribute flow templates inside of your organization by sharing copies of flows. Once you have sent out a flow, your colleagues can create it from their email,…

In this 2 minute Tuesday, Patrick looks at how to use Excel and OneDrive with Power BI For Collaboration. Using this approach, you can easily keep Power BI updated when team members update an Excel sp…

Within PowerApps you can send data to PowerApps using the Ask in PowerApps in dynamic content. This quite quickly means that you end up with a lot of parameters when you want to pass a lot of data to …

DST Refresh Date Function Power BI Service. For Power BI service, the local time is UTC (Universal Time Coordinated). Quick tip on creating a custom function to get local time year-round, even with da…

These days, Dataflow (Power Query in Power BI Service) is a new feature that has been released. according to[1]: Dataflow is a Power Query process that runs in the cloud independently from any Power B…

Learn how to do a bulk find and replace in power query based on a list of values.

I have often been asked (and wondered myself) if it were possible to move all the measures from one Power BI PBIX file into another. Imagine you have 2 PBIX files with similar data models (similar…

In the last two articles, you have learned what is Dataflow and sample use case scenarios of that in Power BI, and also you learn how to create a dataflow. Before going any further in the dataflow dis…