Power BI

Requests limits and allocations

Infographic with PureViz modifying position and percentage fill

Calculation groups are one of the most powerful features to reduce the data model complexity and measure redundancy!

What?! Exploding Measures I hear you say. Exploding, expanding, use which ever word you like; what I mean is when you want to remove any refence to a measure INSIDE another measure. Example Consider the 3 measures below. Total Sales = SUM(Sales[ExtendedAmount]) Total All Product Sales = CALCULATE([Total Sales],ALL(Products)) % [...]Read More »

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night. Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript Backup and restore datasets with Power […]

Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX correctly. This article introduces the row context, and is part of a series of articles about evaluation contexts in DAX. Most newbies start writing DAX code by creating sim

This article is part of a series of articles about the basics of DAX. In a previous article, we introduced the first evaluation context in DAX: the row context. If you are not familiar with the row …

Official Sites & Documentation Name Link Power BI Custom Visuals Gallery https://appsource.microsoft.com/en-us/marketplace/apps?product=power-platform%3Bpower-bi-visuals&page=1 Power BI REST APIs Documentation https://docs.microsoft.com/en-us/rest/api/power-bi/ Power BI adoption roadmap https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-overview Power BI implementation planning https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-introduction White papers for Power BI https://docs.microsoft.com/en-us/power-bi/guidance/whitepapers Microsoft Power Platform and Dynamics 365 product roadmaps https://powerbi.microsoft.com/en-us/roadmap/ Power BI guidance documentation https://docs.microsoft.com/en-us/power-bi/guidance/ Power BI Embedded Analytics Playground https://playground.powerbi.com/en-us/ Community

Learn how admins can get insights on users who are connecting to Power BI datasets from Excel with the Power BI activity logs

This post shows how to Show measures in tabular format with calculation groups. Getting format strings right is the trickiest part, and we find some limitations

Overriding calculation items in tooltips is not straight forward, but using calculation groups inside measures is a convenient workaround

I needed to pull some user data for an app that uses Intercom. While I will probably import the data using Data Factory or a function in the long term, I needed to pull some quick data in a refresh…

Circular dependency error is one of the most annoying things in Power BI data modeling! Learn why this is happening and how to avoid it

External tools provide additional functionalities and features, that will make your life as Power BI developer much easier!

Now that we have introduced the technology in the previous blog post, Introduction to Power BI Dataflows, this post will cover topics about the authoring experience, some important considerations, basic architecture, and Do’s and Dont’s.

When I decided to write this blog post, I thought it would be a good idea to learn a bit about the history of Business Intelligence. I searched on the internet, and I found this page on Wikipedia. The term Business Intelligence as we know it today was coined by an IBM computer science researcher, … Continue reading Business Intelligence Components and How They Relate to Power BI

Bravo for Power BI is a powerful toolkit that you can use to analyze your models, format measures, create date tables, and export data.

Last week, I had the pleasure to meet up with the amazing community again in London at SQL Bits. As very first thing, I want to express my appreciation and gratitude to those who were in the organi…

Welcome to the March 2022 update. We are happy to announce a couple new features this month! How about error bars for line charts and dynamic format strings support for all chart elements? Also, we have some updates to the Azure Maps visual and Sensitivity labels, datasets hub and Power BI Goals. There is more to explore, please read on.

What are the rumors and misconceptions about Power BI out there which are not correct? in this article, you will learn about those.

Making sure that you do not have referential integrity problems is not easy. The Script for Referential Integrity Check Measures will automate most of the work.

When you’re looking at the Log Analytics data for your Power BI Premium dataset, or studying a Profiler trace, you may see a command called ExtAuth in the OperationDetailName column: It is do…

This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the

Showing Measure Description in tooltip is not straight forward. With DMV and a couple of calculation groups is possible to achieve it.

Using the bookmark navigator, I will show you how to let your users choose what is displayed on the tooltip according to their preferences. By using this approach, you are able to switch easily between different tooltip pages without having to create multiple tooltip report pages SUBSCRIBE AND WATC...

Today, we’re happy to announce significant performance improvements to backup and restore operations for datasets in Power BI. Our benchmark tests with 1GB, 5GB, and 10GB datasets show backups can now be completed up to 22 times faster than before, and the time required for restore operations can also be reduced by more than 30%.