Power BI

In this blog, you will learn how to detect abnormal behavioral patterns, outliers, and anomalies in your Power BI data sets.

La Data Web will show a bit of Python code in order to connect our work with the Power BI Service API. This post will help us to obtain the access token with pure urllib Python 3.7 code. What is special in this post is that we will use the Power BI API without the “grant permission” of the Azure/Off...

Use PowerApps checker to see a list of potential issues in your Microsoft Flows.

JUS - The Journal of Usability Studies

The report represents Average Sunshine throughout the year by Continent, Country and City. I have used custom charts for the animation. Below is the information of the charts used in this story. Sunburst Globemap Play axis Clustered column charts Table Slicer eyJrIjoiZGQ4MjQyYzctNDczMC00YzkwLWE5O...

Power Platform admin center gateway management enhancements

Power Platform admin center gateway management enhancements

Environments are containers that administrators can use to manage apps, flows, connections, and other assets; along with permissions to allow organization users to use the resources. The purpose of this article is to walk through important details about environments in the Power Platform and discuss recommended ways to benefit from proactively managing them.

One of the many benefits of Power BI is the possibility to create your own theme file, which defines many design properties of a report, like colors, fonts, and many more. There are also tools on the internet that help you to create such a theme file. But, as you will see, there are some undocumente...

Patrick shows you how to be efficient in Power BI Desktop using keyboard shortcuts for the DAX Editor. It is crazy bananas! Documentation: https://docs.microsoft.com/power-bi/desktop-accessibility

Premise There’s a requirement to sequentially traverse a collection in PowerApps. The issue is that, unlike a normal array in any programming language, we cannot directly access a collection&…

The next chapter in this series on Creative Aggs looks at Filtered Aggs, what they are, and how you might use them to speed up reports connected to Power BI and SSAS models. The series so far : Int…

The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and dataset that fully rely on...

The Power BI gateways are a way to load data from your On-Prem location into PowerBI.com. Read this article to learn how to install gateways with failover.

A special episode of the series Bad Practices in Power BI WARNING!! The following article contains images and Power BI bad practices that experienced Power BI users might find disturbing and inappropriate. Accordingly, reader discretion is advised. About the Author: Ruth Pozuelo Martinez is the MD and owner of Curbal AB, a BI consultant company …

You've seen charts & dashboards... so now let's look at Forms Pro & Power BI. Microsoft have provided a Power BI app that can be installed from AppSource.

<p>Earlier this year, we released for public preview Export to Flow, a new, efficient way for you to design easily digestible business workflows in Visio and export them to Microsoft Flow for au…

Learn how to create your own error message for step level errors inside of Power BI / Power Query and when to actually use them.

This session will include a series of visualization and reporting techniques that you’ll be able to leverage in your company’s reports to take them to the next level.

Overview This concept came about while I was working on a Power BI report for the 2018 Ryder Cup. I was attempting to build out an experience to match a design that a professional web/app designer …

The Microsoft Power BI team have released a preview Data Lineage feature and I couldn’t be happier! The Power BI lineage view displays the lineage relationships between all the artifacts in a…

This article provides information to help choose between DAX and Power Query when a table needs to compute additional columns. When building a data model in

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI d…

This week’s Power BIte is the first in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by defini…

Using the default option to aggregate joined tables is terribly slow. Read how to speed this up significantly. Performance join.

In this post I write a simple function component that takes one value and returns a calculated value. This creates a resusable function like feature.