Power BI

If you’ve been following some of my recent posts about improving Power BI refresh performance by partitioning tables you will have seen a lot of screenshots that look like the one below: It&#…

In week 26 of Workout Wednesday for Power BI, I asked people to calculate the age of Nobel laureates at the time they received the award. I provided some logic, but I didn’t prescribe how to …

dynamic labels and calculation group precedence seem unrelated, but need to go hand by hand. This article shows a technic to avoid the dangers.

How to modify the basket analysis measure to compute the Sales Amount of orders that have both products selected? This unplugged video show how we analyze t

It’s been a while that I use Microsoft To Do to organise my daily tasks. From work-related tasks to buy groceries. While Microsoft To Do is super easy to use but there are some challenges in using it more efficiently, especially when you have multiple O365 accounts within different organisations. Here are some of the … Continue reading Integrating and Visualising Multiple Microsoft To Do Accounts with Power BI

Microsoft has released a Power BI Adoption Roadmap, roughly 150 pages of guidance for organizations using Power BI to get the most value out of their business intelligence investments. Melissa Coates wrote the document, working closely with Matthew Roche of the Power BI Customer Advisory Team (CAT).

That’s right! I’m starting a new blog site today. Just to be clear, it will not replace this one. I will continue to post here at SqlServerBi.blog about everything related to Business I…

This blog post is following on my previous posts using community tools to improve your data model. Previously we used Tabular Editor: here and here. Now let’s define what RI (referential integrity) …

In this tutorial, you’ll learn about what data caches do in a DAX calculation. You’ll understand how they work with the formula and storage engines to provide answers to your queries.Download Free Resources HereWhat Are Data Caches?The storage engine interacts with the formula engine in the form of a

This tutorial will discuss about materialization for data caches in DAX Studio. This post will show how it affects your calculation while generating results with your query. You’ll learn which materialization is better in order to maximize DAX’s performance.There are two ideas of materialization: Ear

Increase Power BI refresh parallelism using the maxParallelism property of a TMSL Sequnce command

Even though he lived 2,000 years ago, you’ve probably heard of the Chinese military strategist and general Sun Tzu. He’s known for a lot of things, but these days he’s best known …

We’re pleased to announced that the long-anticipated public preview of the paginated report visual for Power BI reports is now available in the June release of Power BI Desktop.  For the first time, this native Power BI visual allows you to render any paginated report you’ve uploaded to the service in a Power BI report.  And because you can wire up fields from your Power BI dataset to be used as parameter values, thus providing a fully-interactive experience with the paginated report, just like any other visual.

Any successful data strategy is built upon a deep understanding of your data domain. To get there, you need to set up a data assessment framework first.

Data governance is one of the main pillars of enterprise Power BI deployment. Include these core principles in your data governance framework.

Today I’m happy to announce a preview of our new mandatory label policy setting. The mandatory label policy setting requires users to apply MIP labels when they create new content, edit unlabeled content in the Power BI service, or upload unlabeled PBIX files \via Publish from Desktop or Get data in the Power BI service

Using Python and curious how to use it with Power BI? Patrick explores how you can do just that! Python + Power BI can be a powerful combination. Power BI Python documentation: https://docs.microsoft.com/power-bi/connect-data/service-python-packages-support Seaborn Tutorials: https://seaborn.pydata.org/tutorial.html

Learn how to change the direction of a relationship within a Power BI measure using DAX expression with CrossFilter function

There are different ways you can create buckets or groups for your data in Power BI. Patrick shows you how this can be done with Power Query along with a few other options.

This walk-through and resource list will provide an introduction of Power BI's Object-Level Security (OLS) and when combined with Row-Level security (RLS), you can secure and hide specific metrics, measures, tables, or columns from report viewers when using Roles.

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to impr

[vc_row][vc_column width="1/1"][vc_single_image media="88175" media_width_percent="100"][vc_column_text]In this Power BI tutorial, you'll learn how to connect directly to Microsoft Forms within Power BI. […]

I’m thrilled to announce that the new Power BI Adoption Roadmap is out! The goal for this new documentation is to help organizations know what is involved with adopting Power BI successfully. For the most part it’s targeted to orgs who have Power BI deployed to a certain extent, yet know there’s

Understanding the details behind all the different roles and access controls you can have when governing your Power BI content can be a bit confusing sometimes. I often struggle to remember what tenant settings can I use to restrict users from publishing content, the different roles users can have in workspaces and what they can and can't do in each one of those roles. To make our life easier, I will try to summarise in an easy way how you can restrict users from publishing and accessing content

Someone told you that SSRS and Paginated reports are dead? Check once again, as brand new Paginated Report visual in Power BI is here to stay and enrich your reporting solutions!

Power BI is integrating with the Microsoft Teams activity feed. This release adds notifications for report sharing and request access for reports. This helps you get more done without leaving Microsoft Teams or hunting through your emails. Learn more…

Learn how using data can help you understand and improve your business. Power BI lets you easily unify data from many sources to create interactive dashboards and reports that provide actionable insights to drive your business. This training covers an overview and demo of Power BI to show how you can get maximum value out of your data in a way that was previously not possible.

One of the key success factors for organizations to thrive today is adopting modern self-service business intelligence tools and transforming their businesses to become more agile, more automated, …

In this blog post I compare loading historical data between Power BI Premium Per User and Azure Analysis Services.