Power BI

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

BigQuery team recently released a fantastic new functionality, when using BI engine, all the statistics are saved in the INFORMATION_SCHEMA. When using BI Engine one major pain was it was not very …

I’ve come across many charts like this in the wild. They’re not bad charts, they serve a purpose, but they could be better.  Bar charts are created by encoding data by length. It is commonly thought that when people read bars, they are comparing length, not position. The axis starts at 50%, rather than zero,… Continue reading Thinking about target bands

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow…

What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script! Delete Group/Workspace API: https://docs.microsoft.com/rest/api/power-bi/groups/delete-group AddUserAsAdmin API https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin Power BI PowerShell CMDLETs https://docs.microsoft.com/powershell/power-bi/overview?view=powerbi-ps PowerShell Script: https://github.com/itsnotaboutthecell/PowerBI-cmdlets/blob/master/notebooks/PowerBI_Delete_Orphan_WS.ps1

In this session, Krish will show you how you can use Power BI to easily create 'real' real-time scenarios using Streaming Dataflows.

How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle? Check how Calculation Groups can help you to achieve (im)possible!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! –This Year let Source = Sql.Databases(“servername”), AdventureWorksDW = Source{[Name=”databasename”]}[Data], internetsales = AdventureWorksDW{[Schema=”dbo”,Item=”pbi_InternetSales”]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear –Last […]