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

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

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

Button Slicer Enhances the Power BI Visualization

The Button Slicer is one of the recent visuals that is very helpful in taking your report layout and visualization to the next level. Although this visual has been available for some time, many are still unfamiliar with its features. In this article and video, I’ll take you through this visual, its features, and how Read more about Button Slicer Enhances the Power BI Visualization[…]

Delta Lake Table Structure Demystified in Microsoft Fabric

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

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

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

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

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

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

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

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