Power BI

In the final part, we will take our analytics skills to another level! Not just that - based on the insights unlocked, we will recommend certain actions!

Dealing with estimated data often gives you numbers with more precision than you need or trust. Dynamic Rounding can create gains in performance.

Some Power BI report design skills take years to master. These basic visualization concepts are easy to learn and they will make your reports far better.

Easily overcome a potential data source issue when migrating to Power BI Premium.

Since Power BI launched, we have been listening carefully across our different avenues of feedback to what you, our users, need added to the product. Our Ideas site has been the main place for you to leave suggestions. In July 2020 we migrated to a new platform using Dynamics 365 and Power Portals, and we heard from you about issues with the new site. Over the past year, we addressed many of those issues and have recently made a larger update to fix some major problems.

We are excited to announce General Availability (GA) for Single Sign-On (SSO) through the data gateway to cloud data sources that rely on Azure Active Directory (AAD)-based authentication. In addition to Kerberos-based and Security Assertion Markup Language (SAML)-based SSO to on-prem data sources, you can now get seamless AAD SSO connectivity to Azure-based data sources, such as Azure Synapse Analytics (SQL DW), Azure Data Explorer, Snowflake on Azure, and Azure Databricks through an on-premises data gateway.

Today we are thrilled to introduce the newly released Power BI component for Angular. This component lets you easily embed your Power BI reports, dashboards and more into your Angular web application.

Models utilizing XMLA endpoints will reflect refresh details in the Power BI Service!

We are very excited to announce the public preview of a new REST API to query datasets in Power BI by using Data Analysis Expressions (DAX). Among other things, this new DAX REST API helps to address customer feedback concerning programmatic access to the data in a dataset (for example, the idea REST API access to READ datasets with almost 500 votes by the time of this announcement). The new DAX REST API avoids dependencies on Analysis Services client libraries, requires no connection to XMLA endpoints, and works in Power BI Premium as well as in Power BI shared capacity

We are very thrilled to announce the general availability (GA) of Backup and Restore for datasets in Power BI Premium and Premium per User (PPU). Whether you are migrating Azure AS workloads to Power BI or must consolidate Power BI tenants due to a merger or acquisition or simply want to backup Power BI datasets on a regular basis to meet the data retention and disaster recovery requirements of your organization, you can now rely on the Backup and Restore capabilities of Power BI as a fully supported feature.

Stand out from the crowd with an interactive CV built with Power BI. Our BI Consultant, Irene Christina shares this step by step guide.

This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and t

This week the Power BI team announced an awesome new feature. It's the ability to run DAX queries against your Power BI datasets via a REST API. Wow, wow, wow! Given that coding API's might not be something everyone has the ability to do, I thought I'd share how you can use Power Automate to run a DAX query, extract data & save it to a file. Here is a high level summary of the Flow I built: Obtain a Token to authenticate to the Power BI REST APIs Call the new Power BI API, passing a DAX query Pa

Second post in the “Doing Power BI the Right Way” series. In a business intelligence solution, data must be shaped and transformed. Your data is rarely, if ever, going to be in the righ…

Recently I was asked to provide an example of a custom Linear Regression Trendline in Power BI that can dynamically re-calculate for both different levels of a Date hierarchy along with different filter selections. After designing and creating the example, I thought it would be useful to share wit...

In this Power BI tutorial, you'll learn how to build a correlation plot natively in Power BI. Also called a correlation matrix, this plot is helpful to understand how different variables in your data is correlated. Does a positive change in Variable A create a positive change in Variable B? This is easy to plot and understand with a correlation matrix. Check out the video above to learn how to build one yourself without the help of any custom visual or R/Python scripting. ---------------------------------------------------------------------------------------------------------------- To enroll in my introductory or advanced Power BI courses: https://training.bielite.com/ Blog Post/PBIX Download: https://bielite.com/blog/native-correlation-matrix-power-bi/ Cars Dataset Info: https://cran.r-project.org/web/packages/explore/vignettes/explore_mtcars.html Correlation Coefficient Calculation: https://www.statisticshowto.com/probability-and-statistics/correlation-coefficient-formula/ Elite Power BI Consulting: https://bielite.com/ Data Insights Tools: https://www.impktful.com/ Connect with me on Twitter! https://twitter.com/PowerBIElite 0:00 Intro 2:50 Setting Up the Data 5:46 Creating Measures 11:55 Quick Formatting

Calling all creators! Back in August 2016 we introduced predefined matrix and table styles. We are exploring adding more predefined styles to more visual types to save you precious report creation time. We have created this survey to gather your feedback and help us define what these styles should look like.

was listening to this Excellent Podcast about Minerva, basically Airbnb went and built a Metrics Store which is a central tool that hold all Measures and dimensions, the idea is to have one source …

Hello! It’s me, Maya (you can find me on Linkedin here). As usual, I bear with me exciting news: we have just published a new, super-useful update of the Power BI Custom Visuals Exploration Tool. The Power BI Custom Visuals Exploration Tool (install it here) connects directly to AppSource to present all the publicly available […]

A couple of months ago, we launched a new Power BI integration for visualizing SharePoint lists for all Targeted release users. We’re now excited to announce that the experience has rolled out to Standard release users and is now accessible to everyone!

The popularity of Power BI has increased dramatically in the past few years. I am seeing an increasing number of enterprise customers who built complex composite models combining import tables with DirectQuery tables. Many users have asked questions on how DAX queries and measures are tran

Learn how Power BI approaches its site reliability model.

I’m excited to share a new whitepaper that describes the Power BI team’s approach to maintaining a reliable, performant, and scalable service for our customers.

Learn how to perform fuzzy grouping and matching in Power BI and Power Query in a few steps described in this article and video

Recently I started a blog series on different topics that come into play when you want to transform a local (small scale) solution into a global (enterprise) solution. I started this series explain…

Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the non-blank rows.

As promised, today I am sharing with you the process I went through to build the COVID report I shared in my last article. One of the best ways to learn and improve your Power BI skills is to practice. The best way to practice is to find something you [...]Read More »

This blog post compares the logging capabilities between Power BI Premium Per User and Azure Analysis Services.

Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns from tables is a very common challenge of data-cleaning. The tutorial in mention, which happens to be one of our most popular tutorials on DataChant, addressed […]

Welcome to the July update! This month we are making small multiples generally available, as well as the new model view and sensitivity labels in Desktop. Also, we have a new preview for streaming dataflows. There is much more, so read on!