Power BI

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.

Removing the top five rows from a data set is easy in Power Query, but what do you do when you need the number of rows changes? There isn’t a built-in Remove Dynamic Number of Top Rows function. In this post we’ll look at how to set this up...

Let's take the opportunity to learn the most common uses of bookmarks nowadays. Bookmarks are one of the most used hot features in Power BI at the moment. In this post, we are checking out three killer ways to use them. First, we are going to activate the Bookmark Pane to start using them: Book...

Puzzled when to use Power BI Premium vs Azure Analysis Services? Power BI Premium is where future investments will be made but there are things to consider when making a choice.

In the first part of this series I talked about why you might want to test the performance of a Power BI report in the browser, as opposed to using Performance Analyzer in Power BI Desktop, and the…

In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to add on-premise source in the Enterprise gateway prior to the creation of dataflows....

This is a long overdue post, probably one of the most received questions on my blog was, How I designed a visual in one of my Power BI reports I…

As I continue to explore and develop best practices for managing serious business-scale Power BI solutions, I’m having conversations with recognized community leaders. Last month I chatted w…

Run your Cohort Analysis in Power BI and find out if your newer customers are becoming more loyal and spending more. Extremely useful for website analytics.

If you created a Tabular model using one of the preview versions of Tabular Editor, you don’t have the final structure for the Ordinal attribute that Micr

Visit the post for more.

If your Power BI report is slow, most of the time the reason is something to do with the way you have modelled your data or the way you have written the DAX in your measures. There are plenty of re…

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your dat

This article describes how you can create a comparison with the previous time period in a visualization, regardless of whether the time periods are consecut

The default behaviour of the slicer in Power BI is that it shows the result of OR when you select multiple items. For example, if you have a slicer for product colour, and then you select both "Black", and "Blue" the result would be all records that have "Black", OR "Blue". Of course, you won't…

I have written about both types of parameters in Power BI; Power Query parameters and also the What If parameters. However, still many people are not aware that these two are different, and serve different purposes. In this blog article, I am explaining the differences between these two types of parameters, as well as the…

You can concatenate a list of values in Power BI in two ways; Using Power BI DAX functions such as ConcatenateX, or through Power Query. For some scenarios, there is an advantage in using Power Query to do the concatenation. In this blog article, I'll explain how this works. If you like to learn more…

I have previously written about how to calculate the same period last year calculation and compare this year's values with the last year's values. However, sometimes, you don't yet have the full year, especially for the current year. You might want to compare this year's value with the last year's value up until the same…

It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of October and November.

In this Power BI webinar, we learn about creating agile metrics and see some of the reporting capabilities when we connect Power Bi Desktop to data flows using parameters and functions to populate entities.

Learn how to use the US Census API to return the average house hold income. Click here to learn how to call custom APIs in Power BI.