Power BI

This post started as a response to this question from Mark, who was commenting on last week’s data lineage post: How would you decide how big or how small to make each artifact in the lineage…

Parent-Child-Hierarchies with multiple parents cannot be created with DAX. But with an M-function in Power Query it's possible if you build the model accord

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days of learning about DAX. Let's…

If you’re a frequent reader of this blog, or a frequent user of Power BI dataflows, you probably know these things already: Power BI dataflows are workspace-level objects in the Power BI serv…

Microsoft Azure provides compelling, best-in-class tools for data storage, analysis, orchestration, security, and AI. When combined with Power BI, data analytics and outcomes are unmatched.

Power BI and Azure Analytics help businesses build a data-driven culture and drive analytics proficiency.  This has been seen in recent findings from the commissioned Forrester Consulting study, The Total Economic Impact™ Of Microsoft Azure Analytics With Power BI. The study specifies that together, Azure Analytics and Power BI can provide value to customers by delivering an ROI of 271% over three years. 

I have written previously about what is a fact table, and what is the dimension table, and how they relate to each other in a Power BI data model. However, still I see when people use these tables in their model, they get ambiguity of what table should be used for what, and if they…

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 – 9:30 AM Pacific Time.

As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, …

Phil sits down with us to walk through his process in debugging a slow Power BI report. This uses some new features in Power BI Desktop as well as using DAX Studio to get further insights. Connect with Phil Twitter: https://twitter.com/PhilSeamark Blog: https://dax.tips/

Power BI Training Content http://aka.ms/PBItraining The Power BI engineering team develops and maintains several workshops and classes that are available to our partners and community leads for free to help them to train their customers and communities on Power BI. Every class will include all mat...

As report authors we sometimes get caught up in how easy it is to create a report and provide value to the business. Each report [...]

I was doing some work recently which required DAX calculations to convert values from a specific base to another, e.g. to convert a value in hexadecimal format to a base 10 representation (or decim…

The PowerApps component framework for model-driven applications along with PowerApps CLI have been released to general availability.

Best practices for Power BI dataflows

Introducing the OnReset property of components. With OnReset, you can specify behavior formulas that run when an event resets a component. Read details and examples.

REMOVEFILTERS() is a new DAX function that was created to make the language easier to learn and understand. Learn why REMOVEFILTERS() was introduced here.

When you have 100 reports.... When you have a lot of dimention.... When you have thousands of entities, If you need to query the entire system, to understand: where does the data come from? which entities are read? which "job" is launched? Is the call manual or timed? Entity XXX, which Factabl...

If you have been using T-SQL queries to build the tables of your Power BI data model, you probably know what I'm talking about. Sometimes after a while using a query in the Power BI model, you might change the script and want the change to be applied in the data model. One of the…

In this article I will show you how to create a re-usable calculator control component in PowerApps. We will use buttons and text label controls to

In this post, we will look at how to install and use the Microsoft Flow Add-In for Excel. First, open Excel and go to Office Add-Ins, then select Microsoft Flow for Excel (Preview). Click Add: You will see: The Add-in is now ready to use. Let’s create a new spreadsheet, Customers, with a column for the Customers, and we will make this selection a table by highlighting then selecting Table … Continue reading Installing Microsoft Flow Addin for Excel and Selected Row Email Demo

A practical example on what PowerApps dataflows, Excel and Power BI can offer you in combination with one another and what other benefits it brings to you.

In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.

This post describes how to build a multi-step function in M using a parameter and using create function to build the function code.

While the documentation on how to import data from Azure Data Lake Gen2 Storage into Power BI is pretty detailed, the connector (which at the time of writing is in beta) that supports this function…

PowerBI Administration and Monitoring Report Features Monitoring all your Gateway and receive alerts whenever your Gatways got offline Always keep upto date with all your gateways Explained detailed in the bleow Blog Series Series Part 1 https://community.powerbi.com/t5/Community-Blog/...

Table of Contents1 Which part is slow?2 Tuning the data refresh2.1 Verify that query folding is working2.2 Minimize the data you are loading2.3 Consider performing joins in DAX, not in M2.4 Review your applied steps2.5 Make use of SQL indexes3 Tuning the model calculations3.1 Use the Power BI Performance Analyzer3.2 Confirm that the storage engine … Continue reading A comprehensive guide to Power BI performance tuning →

I've been asked from one of my friends who were trying to create a random dataset for his presentation. There is a great and quick way that you can create a random list of numbers in Power BI using Power Query. In this short blog post, I'll explain how to create this random list. You…

Learn how to use DAX to create a custom TEXT column sort order. This tutorial explains a simple solution to ordering items. Click here to learn more.