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

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!