Power BI

Last week I kicked off the new BI Polar YouTube channel with a video and blog post comparing and contrasting Power BI dataflows and datasets. In the days that followed, I continued to hear questions t…

<p>I am excited to announce that PowerApps Portals are now generally available.  </p>

<p>Rules in canvas apps is a feature that let you record actions to be performed under a condition which you can write an expression for. The current implementation of the Rules feature will be …

<p>We announced in July licensing options for PowerApps and Microsoft Flow.  These are available to purchase from the Office admin center and you can now allocate add-ons in the Power Platf…

<p>You now have a new tool to better understand, debug, and improve your apps.  Similar to a network trace, Monitor provides a running list of all the activity within your app.   …

Whether you want to analyze an individual workspace or your full Power BI environment (all workspaces and solutions you are an admin of), you will find the Power BI Data Dictionary solution invaluable…

This is a long-overdue blog post. A couple of months ago, I worked with a client in Amsterdam; one of the use cases was to show key metrics, flags that…

This question comes up pretty regularly, I have a big screen in my hallway and I want to show some Power BI reports that rotate. Now there is some build...

Pubic preview- PowerShell gateway

Today, we are making scheduling of refreshes much more flexible to improve how Power BI works in processes like the ones described above. Specifically, we have added a new Refresh a dataset&#…

This month’s update is filled with major updates across the whole product. In the data preparation area, we’ve introduce query diagnostics, which allow you to see what que…

For this blog, I want to share an interesting data modelling technique which you might consider when having performance problems with time intelligence calculations. This particular pattern works w…

In this blog, I will show how to create a flow that can be used as a service. We will create a customer request management service using Flow,

In this blog post we will have a look at how to display managed metadata terms as labels in a gallery in PowerApps.

PowerApps is a great platform to create great looking custom forms, although there are still some hick-ups and missing features, which require some workarounds. However, PowerApps forms are great if you want to create custom line-of-business applications which use custom forms to interact with users

Learn about the fundamental security and compliance capabilities offered with Microsoft Flow.

The Microsoft business applications virtual launch event is almost here! You don’t want to miss this opportunity to get a first-hand look at the new innovations we’re rolling out for Power BI. Register today for this free event, and then tune in to the live stream on October 10, 2019 from 8:00 AM – ...

In another blog article, I explained how easy is to use table constructor in DAX to create a data table fast in Power BI. However, that method has some limitations, such as not being able to name columns or set their data types. In this blog post, I'll explain about DataTable function in DAX which…

This is a tutorial on how to build a Filled Donut chart. It is a fun quick tutorial focused on using multiple visuals, bookmarks, and buttons. Click Here.

This Power BI Blog post details how to bulk change permissions when using datasets when using the Power BI App in the Power BI Service

Patrick shows how you can easily use parameters, for your data source, within Power BI Desktop with minimal clicks. All about reducing the clicks!

If you’re using a SharePoint choice field you can set the ‘Allow fill-in choices‘ (or ‘Can add values manually‘ in modern) option to yes. This will give users the opportunity to manually specify a value for the choice field if the given values are not sufficient. E.g. when a user want to request a brush, […]

Often web based data is split across multiple pages. This post describes how to use a function to fetch web data from multiple pages by using parameters.

This post describes how to create a function that executes an SQL procedure, passing in a parameter and how to avoid the security question.

Image a scenario where your column in your PowerQuery that contains a table with a set a columns that you know at some point will have more columns added. In the case above I know that we at some p…

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case ins…

Power BI dataflows have included capabilities for data lineage since they were introduced in preview way back in 2018. The design of dataflows, where each entity is defined by the Power Query that …