Power BI

Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a st

This week I am attending the Power BI Partner Bootcamp on the Microsoft Power BI campus and got to play with the latest AI capabilities. AI is becoming a gamechanger in Power BI as a catalyst for insights. With R and Python integrations, the Auto ML in Dataflows, Key Influencers, Decomposition Tree, and the new …

Visit the post for more.

Visit the post for more.

THis blog post details how I saved over 40% on the dataset and memory size in my Power BI Model and how others could do it too.

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations ca…

I see you thinking about my title… I know Microsoft Flow is now renamed to Power Automate, but then my title just doesn't have the same flow of reading anymore @NickyvV speaker 4 of 8 at @DublinPUG #PowerPlatformWT A form, a Flow and a PBI streaming dataset walk into a bar. pic.twitter.com/Jr8WX...

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…

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…

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…

Visit the post for more.

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

Visit the post for more.

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.

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

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.

December 2019 is a major update in Power BI Helper. We believe this is the biggest update we have done so far. The list of updates is big. To name a few, now we have pages, visuals and bookmarks metadata available, visual comparer, visualization tree, the reverse dependency tree, DMV execution page, and dependant calculations…

The year flew by pretty fast! With 2019 in the books, it’s time to have a look back at all awesomeness that happened this year! Time to say goodbye to 2019 and welcome 2020 with a short look …

Get rid of unused elements in your Power BI files easily with the new Power BI Cleaner tool. It automatically detects all unused fields in your PBI file.

The Power BI 2020 Salary survey was popular enough to get some interesting results. In this post, I am sharing the result of that survey (which is filled by the public) as a Power BI report. The report gives you an overall idea of how much the minimum, maximum, and average salary should be based…

I conducted a workshop in Florida recently, aimed at helping people to move from Business Intelligence to Analytics. I thought I’d post the slides here. If you have any questions, please get …

Back in May 2019, I introduced the Power BI Pixel technique to track usage on Power BI. In today’s post, I will share the detailed implementation steps to help you build your own Power BI Pixel and track users and the filter selections they make in your Power BI report. Note: If you care about …

Different modeling approaches can speed up performance of your Power BI dataset - albeit with the tradeoff of additional complexity. One situation is where users need to access a very large dataset, but typically apply the same set of filters - resulting in a small subset of rows meeting the needs of most queries. A sliced aggregate approach (implemented in the data model + DAX) can be used to make your models performant where they need to be, but still allow the full range of reporting.

In Power BI the Key Influencers visualization uses multiple linear regression models. Explore these models, what exactly they are, and how they work.

Learn how to work with SharePoint Multi-value columns in Power BI! You learn the basics as well as how to set up the model to enable value filtering.

Recently, I was faced with a very interesting problem. I had developed a complex dataset. Beside that there are more than 200 reports using a live connection to this dataset. A report’s user had come and asked for negating a Boolean value of a column – because I had misunderstood the meaning of the ...