Tag: Power BI from Rookie to Rock Star

Lakehouse VS. Warehouse VS. Datamart – The Difference Between The Three Fabric Objects

Posted on by Reza Rad

Three types of objects in the Microsoft Fabric have similarities in what they can do for an analytics system. These three are; Lakehouse, Data Warehouse, and Power BI Datamart. All three objects provide storage for the data, which can be loaded into them using an ETL process and read using something like a Power BI Read more about Lakehouse VS. Warehouse VS. Datamart – The Difference Between The Three Fabric Objects[…]

Microsoft Fabric Licensing: An Ultimate Guide

Posted on by Reza Rad

Microsoft Fabric is an end-to-end data analytics Saas solution product of Microsoft. It brings many workloads in the analytics area, including Data Integration, Warehousing, Engineering, Business Intelligence, Data Science, and Real-time Analytics. It is often a question of how the pricing of this platform works. This looks expensive, and how much I should pay for Read more about Microsoft Fabric Licensing: An Ultimate Guide[…]

What is Data Factory in Microsoft Fabric

Posted on by Reza Rad

Microsoft Fabric is an end-to-end data analytics solution in the cloud, and one of its workloads is called Data Factory. In this article, you will learn what Data Factory is, how it works with the rest of Microsoft Fabric, and what are elements and functions of Data Factory. Video Microsoft Fabric To understand Data Factory, Read more about What is Data Factory in Microsoft Fabric[…]

Getting Started with Dataflow in Microsoft Fabric Data Factory

Posted on by Reza Rad

The Dataflow in Microsoft Fabric is an element for getting the data from the source, transforming it, and loading it into a destination. In this article and video, we will go through what Dataflow is and how it works with a simple example of it. Video What is Microsoft Fabric? Microsoft Fabric is an end-to-end Read more about Getting Started with Dataflow in Microsoft Fabric Data Factory[…]

What is Microsoft Fabric, and Why it is a Big Deal!

Posted on by Reza Rad

You might have heard the news of the announcement at Microsoft Build by Arun Ulag and the rest of the Microsoft Data and Analytics Platform team. The announcement was about the new service offering named Microsoft Fabric. In this article and video, I want to explain what Fabric is and why you should care. In Read more about What is Microsoft Fabric, and Why it is a Big Deal![…]

Power BI DAX: ALL vs. ALLSelected

Posted on by Reza Rad

These two functions in DAX are often used instead of each other; ALL and ALLSELECTED. Their behavior can be similar in some contexts, but it can also be different in other contexts. In this article and video, I’ll explain the difference between these two functions and when to use each in DAX for Power BI, Read more about Power BI DAX: ALL vs. ALLSelected[…]

FORMAT Visual in the New Power BI Desktop

Posted on by Reza Rad

Where is the Format visual option in the new Power BI Desktop? There is a simple answer to this question, which I explained in this blog and video. This change applied from March 2023 version of Power BI Desktop, and by the time you read this article, it might be at general availability and the Read more about FORMAT Visual in the New Power BI Desktop[…]

Power BI Components

Posted on by Reza Rad

Power BI is more than Power BI Desktop. It is a combination of some components. Learning about these components and their role in the solution is important before any further steps. It is impossible to talk about architecture when you don’t know about Power Query or Power BI Service. Each component plays an important part Read more about Power BI Components[…]

Row Level Security in Power BI Desktop

Posted on by Reza Rad

Another aspect of sharing is the security of the dataset. Enabling different roles and giving users access to different levels of data is called Row Level Security. This post explains the details of this security method and how to configure it in Power BI Desktop. Row Level Security enables you to apply security to roles Read more about Row Level Security in Power BI Desktop[…]

Dynamic Row Level Security with Power BI Made Simple

Posted on by Reza Rad

There are different methods to use row-level security in Power BI; You can set up Row Level Security in Power BI itself or through a live connection from a data source such as SSAS Tabular. However, row-level security defined in the ways mentioned in the articles above isn’t dynamic. By dynamic row-level security, I mean Read more about Dynamic Row Level Security with Power BI Made Simple[…]