Power BI

Feb 2020 gateway release

Working with APIs in Power BI? This article provides some suggestions on how to work efficiently with API calls in Power BI.

Are you flows slow, and did you wish that you could take your flows out of the stone age? Flow performance can be very important.

We are pleased to announce that we are optimizing connectors through enhanced validations. This means that all of the connectors you use, whether it’s one of the almost 300 out-of-box connectors provided by the Power Platform, or one of the custom connectors built within your organization, will see fewer run time errors, and a more consistent, and maintainable, experience. 

This blog post covers the latest updates for Power BI embedded analytics and Power BI visuals platform

In this video, Manu and Paul provide details on various support scenarios and options for Power BI. This series provides a structured approach for developing...

Reading Time: 2 minutes Many organizations deploying Power BI rely on one or more standardized template (.PBIT) files. Especially when paired with a custom theme, templates help create consistency for branding or other reasons. Perhaps you want to open the same PBIT (or PBIX) every time you open Power BI and don’t want to rely on finding and opening…

Benford's law test in Power BI allow dynamic measures that let you cleverly compare relevant parts of your data and trigger alerts automatically.

Natural language query was probably the most unused feature in Power BI, until they introduced the new Q&A visual in the end of 2019. I’m a huge fan of this feature, but it is sometimes a…

Send Power BI alerts to users via Teams using Power Automate and format the data using Adaptive Cards

Last week’s post showed an M function that took Power Query diagnostics data and formatted in a way that made it suitable for visualisation in a Power BI Decomposition Tree visual. This is gr…

More than a year ago, a question was asked on the Power BI community in regards to showing a heat map in Power BI. Not just a simple heat map in the matrix visual, but a heat map based on data smoo…

A few months ago, a very interesting question was posted on the Power BI community forum and I had the opportunity to work on it. Finally, I have the time to write a blog post about this so that we…

The new Power Apps components feature adds a lot of options for reusing elements within your App. In this post I will look at how to size Power Apps components

The change to the Publish to web default experience announced in 2019 will start rolling out this week. It requires Power BI admins to take action before users can create new publish to web embed codes. This blog help you understand what users can expect and what actions admins should take as the change rolls out.

Power BI Seed every BI engineer needs to build out consistent great navigation in Power BI

I came across an interesting request last week from someone who wanted to dynamically control columns shown in a Power BI table visual – based on the values within each table. There are lots …

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter)…

Here is another interesting use case of Row Level Security (RLS). It’s funny that my first post was also about RLS – when you use RLS, lot of different challenges show up (which are not…

Technical articles, content and resources for IT Professionals working in Microsoft technologies

You NEED to be aware of how Publish to Web works in Power BI and how to prevent data exposure.

We are excited to announce the release of a new and improved usage report for Power BI reports in modern workspaces.

<p>In the January 2020 update, AI Builder introduces a new and simplified way to use AI Models in Power Automate. It is now easier to provide your data to the AI Model, and to use the output without the need to manually transform data.</p>

<p>How do you enable a line of business with  4000+ employees, across multiple geographic locations, to attend a mandatory in-person training event closest to their location, with a limit of 150 attendees per session and a target completion of 12 weeks  Microsoft BAG (Business Applications Group) Operations team used Power Apps Portals from the Microsoft Power Platform to quickly and painlessly enable employees to register, manage, and complete the mandatory training.</p>

Recently I’ve been working with the Power Query team to come up with some ways to help developers understand the data returned by the new Power Query diagnostics functionality. In this, the f…

Aggregations is one of the key feature in Power BI and it helps to analyze large datasets without any performance impact.New to aggregations? read this to get a better idea. once we designed aggreg…