Power BI

Configure the API authentication to retrieve the token and return required data in Power Query

Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns. The DAX language is commonly used to create measures and

Learn the internals of Power BI semantic models created by using VertiPaq, DirectQuery over SQL, and DirectQuery for Power BI datasets and Analysis Services

SQLBI+ is our new subscription service to advanced content that support professional model authors who create semantic models for Power BI and Analysis Serv

The ultimate snapshot report shows the latest snapshot while showing the evolution at the same time. It's easy to select a previous snapshot and more.

Recently, I’ve published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and u…

As you may already know, Power BI is not a report-authoring tool only. Indeed, it is much more than that. Power BI is an all-around data platform supporting many aspects you’d expect from such a platform. You can ingest the data from various data sources, transform it, model it, visualise and share it with others. … Continue reading Content Endorsement in Power BI, Part 1, The Basics

Smart date axis with Field parameters

Power Apps drag and drop functionality is now available. We can use it to group, re-order and move objects in a gallery-like container.

This article shows you how to set up a flow on Power Automate for creating a version control system to check all Power BI reports (in your organization) every minute in order to find the reports that have been modified, record those modifications in the Change Log, and export/save them as PBIX files.

Stack that chart, and label that data

Web site created using create-react-app

Contribute to samaguire/PowerBINotebooks development by creating an account on GitHub.

Mathias has published some demos and demo data on GitHub: https://github.com/pbi-toolsIn this video he shows how to get started with them and what do you have.

Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here: There are code samples here: And guess what, t…

Deneb-Vega data visualization examples - Power of Business IntelligencePower of Business IntelligenceBlog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.Andrzej …

Please see Part 1 of this tutorial for background on setting up the cumulative totals and rankings. This tutorial is a continuation that gets counts and proportions of top and bottom features. It then demonstrates how to build dynamic stacked bar charts and descriptive statistics of our top features...

We know the Pareto Principle — 80% of consequences come from 20% of the causes. Or, 20% of your customers account for 80% of your sales. Et cetera. We see this typically displayed with bar charts and a cumulative percentage line stretched across. Most information on how to do this in Power BI does n...

Today we are pleased to announce the release of the modern Learn page in Power Apps! The new Learn experience has consolidated content from all Microsoft resources to help with your onboarding and upskilling journey. The Overview tab of the new Learn page includes a dynamic banner at the top – to help keep you … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/update-release-of-modern-learn-page-in-power-apps/" class="more-link">Continue reading<span class="screen-reader-text"> “Update: Release of Modern Learn page in Power Apps!”</span></a></p>

Today, we’re excited to announce the preview of new process mining capabilities from Minit available in process advisor within Microsoft Power Automate. In addition to the existing process advisor capabilities, Microsoft customers can now harness deeper insights to identify bottlenecks in processes to drive optimization and efficiencies with low-code automation.

When you try to copy large files from SharePoint to Azure Bob Storage with Power Automate, you will find that you have a few options. But quite a few of them

This content applies to: Power Query online Power Query desktop You may have noticed a new M function was added to Power Query recently: Web.Headers. This function allows you to make HEAD requests to web services – the existing Web.Contents function, which it resembles closely, only allows you to make GET and POST requests. You […]

In this article, we examine considerations for implementing & governing Analyze-in-Excel in your Power BI self-service ecosystem.

Here's the rough draft of a few key paragraphs from The Art of Insight : I respect but also disagree with the Tuftean and Bertinian function...

Is your data issue a business intelligence problem... or a change management issue? Can you distinguish these perspectives, or is it differing views on the same thing

As part of the continued Power BI innovations, we’re excited to announce the support for paginated reports in Power BI Pro at this year’s PASS Data Community Summit. Now Microsoft Power BI customers have the flexibility to create and consume interactive reports as well as paginated reports using Power BI Pro. 

This guide will show you how to use the Power Apps Patch Function with SharePoint. Each page contains code and visuals to help you learn.

What does the new ParseJSON function offer for canvas app makers? Let's look at an example for handling order lines data with Power Fx.