Power BI

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.

Hi Everyone! Imagine being able to create .msapp files that your client can import and start using straight away that will default to their branding! Or templates that you can give to your citizen...

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...

Connectors can now be used in canvas components! I am excited to announce availability of one of the most requested features for canvas components, with supporting API data sources as a first step. Check out how it makes components more powerful and interesting.

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.

Read my list of 10 tips I wish to know before I've started with PowerApps and become a PowerApps expert in an eyeblink. Those tips save your time a lot!

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.

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...

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.

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...

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…

PowerApps is a fantastic tool allowing Power Users to create applications with minimal code, quickly. However, as with many types of IDE, it’s very easy for it to become unmanageable and overwhelming as the number of screens, controls and complexity grows. In this post, we’re going to examine several approaches that you can use to …

Designing a good UI is very important for any app. In this blog, I will explain how we can do pixel perfect designing in less amount of time using PowerApps.