Category: Microsoft Fabric

Power BI Default Semantic Model or Custom; A Guide for Using in Fabric Environment

Posted on by Reza Rad

The Lakehouse or Warehouse comes with a default Power BI Sematic model, which can be used for reporting and analytics. However, you can also build and use a customized semantic model. There are significant differences when using the semantic model in real-world analytics projects. In this article, I’ll explain the difference between these two, which Read more about Power BI Default Semantic Model or Custom; A Guide for Using in Fabric Environment[…]

Time Travel in Fabric Warehouse: Query Snapshots of the Data at Any Point in Time

Posted on by Reza Rad

Time travel is now available in Fabric Warehouse, which was previously only possible in Lakehouse. This means that you can all be Dr. Strange and use your time stone to travel through time and look at a snapshot of the data at that point in time. It is an amazing feature, and it is so Read more about Time Travel in Fabric Warehouse: Query Snapshots of the Data at Any Point in Time[…]

Delta Lake Table Structure Demystified in Microsoft Fabric

Posted on by Reza Rad

The structure of storing data in OneLake for the Lakehouse tables is interesting. The commonly used structure is called the Delta Lake Table structure. In this article and video, you will learn what this structure is, how it works, and what the difference is with Parquet, and you will see some related demos. Video What Read more about Delta Lake Table Structure Demystified in Microsoft Fabric[…]

Mirroring Snowflake in Fabric: Supercharged Analytics at No Extra Costs

Posted on by Reza Rad

Microsoft Fabric offers an end-to-end SaaS analytics solution; however, the world is using all kinds of data sources in its implementation. Mirroring is a new functionality in Fabric that allows customers to keep their data wherever they are, but then they can use Fabric analytics solutions with the same speed and performance as if their Read more about Mirroring Snowflake in Fabric: Supercharged Analytics at No Extra Costs[…]

Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2

Posted on by Reza Rad

There has been a lot of hype recently about Generative AI and Copilot in Microsoft. Microsoft Fabric incorporates many of those features, and one of the areas it has been added to is the Dataflow Gen2 in Microsoft Fabric, or we can also call it Power Query in Power BI Service Dataflows. In this article Read more about Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2[…]

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

Data Science in Microsoft Fabric

Posted on by Reza Rad

Microsoft Fabric, as an end-to-end SaaS, provides multiple workloads, including Data Science. In this article and video, you will learn the Data Science workload in Microsoft Fabric, what it includes, and how it works with other Fabric workloads. Video Microsoft Fabric Microsoft Fabric is an end-to-end Data Analytics software-as-a-service offering from Microsoft. Microsoft Fabric combined Read more about Data Science in Microsoft Fabric[…]

What is OneLake in Microsoft Fabric, and Why You Should Care?

Posted on by Reza Rad

Microsoft Fabric is a complete set of technologies that provide Analytics as a service. Fabric uses a logical storage layer named OneLake. In this article, we will explore what OneLake is, what it is important, its essential features, and how it works with the rest of Fabric objects. Video Microsoft Fabric Microsoft Fabric is an Read more about What is OneLake in Microsoft Fabric, and Why You Should Care?[…]

Saying Yes to Fabric OneLake Shortcuts, No to Duplicate

Posted on by Reza Rad

Microsoft Fabric uses OneLake as the single logical layer for storage management across the Fabric. OneLake offers Domains and workspaces to work with Fabric Items, and amid all those structures, you may require a table or file from one Domain to be used in another. OneLake’s Shortcut feature will give you this option without duplicating Read more about Saying Yes to Fabric OneLake Shortcuts, No to Duplicate[…]