Power BI

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…

Learn more about Azure Data Factory, the easiest cloud-based hybrid data integration solution at an enterprise scale. Build data factories without the need to code.

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

By now I hope most people know the (run by Guido Preite). A great page for sharing community components (PCF) and exposing awesome contributions to the rest of the world. 🌎 What I like about the PC…

In this PowerApps tutorial, We will discuss what is PowerApps ForAll function and its syntax, then we will see how to use the ForAll function in PowerApps. Also by taking some simple scenarios, We will …

In this PowerApps tutorial, we will discuss how to embed Power bi report in PowerApps portal. Basically, we will see how to embed Power BI Microsoft 365 Usage Analytics report in PowerApps.Complete …

Power Apps can transform a datasource or a collection into a CSV which can be opened in Excel with the help of Power Automate.

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

Case In a previous blog post about analyzing ADF logs in Azure Log Analytics we mentioned Kusto Query Language (KQL) as the language used f...

The Ingestion and Transforming of data in Microsoft's Azure Platform can cover a wide variety of topics a Microsoft Azure Data Engineer needs to know. This post covers some must-have documentation, tutorials, and demos to help you through the topic.

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. […]