Category: Power BI

Power BI Dynamic Subscription: Send Scheduled Report Filtered for Everyone’s Data Automatically

Posted on by Reza Rad

If you ever want to have a general report for sales for all countries, and then you want every morning the report to be sent (as PDF or PowerPoint alongside the link to the report) to representatives of each country, the report with the data filtered for their country only, then Dynamic Subscription in Power Read more about Power BI Dynamic Subscription: Send Scheduled Report Filtered for Everyone’s Data Automatically[…]

Version Control in Power BI and Fabric

Posted on by Reza Rad

Power BI and Microsoft Fabric use Azure DevOps as the core component for their version and source control. The integration with Azure DevOps and Git helps maintain a copy of the source code and version it. It allows access to it anytime needed, plus the multi-development aspect added. In this article and video, you will Read more about Version Control in Power BI and Fabric[…]

Fabric Real-Time Analytics

Posted on by Reza Rad

Microsoft Fabric offers a workload for real-time solutions. Real-time Analytics can be used for streaming data, such as the data coming from IoT devices. It can be used not only to ingest the data but also to analyze it and use it for other Fabric workloads, such as data science. In this article and video, Read more about Fabric Real-Time Analytics[…]

Microsoft Fabric Domains: Stepping Stones for Data Mesh

Posted on by Reza Rad

Microsoft Fabric introduced a new concept called Domains. Domains are more than just a separation of Fabric data items. They come with a whole lot of security, administration, and governance features, which brings the concept of data mesh into the world of data analytics using Microsoft Fabric. Domains are logical categorizations inside the OneLake. In Read more about Microsoft Fabric Domains: Stepping Stones for Data Mesh[…]

Power Query Template: One Giant Leap

Posted on by Reza Rad

Have you ever considered exporting your entire Power Query Editor project as a single object? Have you thought about what benefits this would bring for you? Things such as version control and team development can be on the horizon, bringing the ability to migrate between tools and services easily. Fortunately, such functionality exists, called the Read more about Power Query Template: One Giant Leap[…]

Data Wrangler VS. Power Query Editor – Microsoft Fabric

Posted on by Reza Rad

Power Query Editor and Data Wrangler are data transformation and preparation tools in Microsoft Fabric. There are similarities between these two tools. However, there are differences, too. It is essential to know the capabilities of each tool to understand which one should be used for what purpose and scenario. In this article, this is our Read more about Data Wrangler VS. Power Query Editor – Microsoft Fabric[…]

Power BI Direct Lake – What is it and Why it is Important When Working With Fabric

Posted on by Reza Rad

With the Microsoft Fabric announcement, There are also additional features in Power BI that makes the connection between Power BI and other Microsoft Fabric objects seamless and more profound. One of these features is the Direct Lake connection in Power BI. In this article and video, we’ll talk about the Direct Lake, how it differs Read more about Power BI Direct Lake – What is it and Why it is Important When Working With Fabric[…]

New Card Visual: Add Images to the Card Visual

Posted on by Leila Etaati

One of the interesting features of the New Card visual is the capability to add images to the Card visual.It added more context to the car visual. In this blog post, I will show some data related to cancer in New Zealand based on gender and cancer type. Now I made two changes first if Read more about New Card Visual: Add Images to the Card Visual[…]

Convert Matrix data in Excel to Tabular Data in Power BI.

Posted on by Leila Etaati

There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data. However, to better analyze data and add more calculations and charts and, in general, get more insight from data, we need to change the matrix data Read more about Convert Matrix data in Excel to Tabular Data in Power BI.[…]

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