Power BI

We discuss one of the latest Power BI features called Quick Insights, a useful tool that can help data novices become data experts in minutes.

Visit the post for more.

Learn how to use custom complex functions bulk-wise on your tables: Advanced transformations on multiple columns at once in Power BI and Power Query.

In the coming weeks we will roll out a change to our default settings that requires Power BI admins to allow public embedding before end users can create new embed codes using Publish to web. The change will not affect existing embed codes, which will keep working as they have been. Read this blog to learn when the changes are coming and how you can prepare.

This December update is packed with several new features! In preview, we have the new Customize theme dialog that allows you to tweak common theme settings without having to write or modify a JSON file! Additionally, we now allow you to export the current theme as a JSON so you can easily share, reuse, or make modifications to the JSON in an editor. Last month, we released the new decomposition tree, and this month, we are adding several new formatting options. With these additional formatting options, you can completely customize the tree to look the way you want and make it really feel li...

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.

Working on a list of Microsoft sessions for Community Summit in Barcelona…please note this is still draft while I confirm the speakers! April 9-12 the Power Platform product team will be in Bar…

Documentation, a tedious task but essential to every piece of technology. Tabular models are no exception to this rule. They contain business rules, calculations, relationships, columns, etcetera. This level of...

This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. As do many languages, D

Today, the new look for Power BI Mobile is generally available (GA) and becomes the default look for all users. You no longer need to turn the new look on in the app settings (and, you also can’t turn it off). So, now when you open Power BI mobile app, you’ll land on the new home page, where you can easily find and access the most recent and frequent items you usually use in Power BI.

<p>We’re excited to introduce a new Power BI sample report for you to play around with. This report includes new features, shows designs factors you should take into consideration when building a report, and has been optimized Power BI Desktop, service, and mobile. You can see how visuals from AppSource can be added to your reports, how they work well with other Power BI visuals, and learn how the Power Apps visual can be used in a report.</p>

You may have seen things that make you say “that’s Power BI AF” but none of them have come close to this. It’s literally the Power BI AF[1]. That’s right – this …

In part 1 of this series I talked about why you might want to test the performance of your Power BI report in the browser; in part 2 I showed how you could test report performance in the browser; a…

Workarounds…..workarounds…..workarounds. We all build workarounds as necessary until more enterprise-ready functionality is made available. This is true for Power BI Usage metrics across workspaces. We have usage models for each individual workspace but there are several issues with them. you have to copy the model in order to edit it and make it useful you […]

I meet a lot of customers in my job, either through the Microsoft field or at conferences and many times we hear the same: “We love Power BI and we...

<p>We love hearing feedback from the Power BI community!  Today, we have another bi-annual survey to keep improving Power BI (both Desktop and Service) with your feedback.</p>

Earlier this week, a client came to me with a DAX error that I’d not seen before… Query (12, 4) Calculation error in measure : The True/False expression does not specify …

Visit the post for more.

Introduction Power BI has been around for a number of years now, however, it’s only in the last couple of years that it’s started to gain heavy use in organizations across the world. Many of us now have access to many reports in a large number of workspaces, and there are a number of challenges t...

With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very c…

Visit the post for more.

The enhanced compute engine in Power BI dataflows has been in preview since June. It’s not really new, and I’ve posted about it before. But I still keep hearing questions about it, so I…

I get many questions around Power BI and security related features. Users and customers often don’t realize that most of their requirements can actually be solved by AAD. Power BI...

The total value that you see in a table is not actually SUM of all values in that column, it is, in fact, the calculation, when there is no filter. This, however, might not be the calculation that we want sometimes. we might want this value to be the sum of values of that column…

Over a year ago, I wrote a blog about Multiple tier architecture and continuous delivery with Power BI, mainly an overview of the setup and manually creating development and production content. Th…

A typical situation in the construction industry the progress data is sourced from multiple system with different format, generally we get two type of reports. Time stamp items My preferred one, th…

This post shows you how to create a custom function for throwing custom error messages in your M code.