Semantic Model
-
Introduction Recently, I was asked by a customer if I knew of a good way to merge the Calculated Measures of two different Semantic Models. The reason for this ask, was that the client was maintaining two separate Semantic Models using the exact same set of tables. The only difference was that one model was…
-
Introduction In Microsoft Fabric, whenever we create a new Lakehouse or Warehouse, a Default Semantic Model is created. However, we can also choose to create a Custom Semantic Model on top of our Lakehouses and Warehouses. A dual-concept which is confusing to many. This blog will try to explain: The TL;DR of this blog: It’s…
-
Introduction Half a year ago, I wrote a blog post on creating Measure Tables in Fabric Data Lakehouses directly in the browser: How to create Measure Tables in Microsoft Fabric – Downhill Data (downhill-data.com). Back then, Data Warehouses were less relevant for the story, as they could not be used for Direct Lake models, and…
-
Introduction I’ve previously written about sharing Power BI Reports with Externals, both through Power BI Embedded (using Power Pages) and to guest users in the Power BI Service. However, a new addition to the line-up of capabilities in Microsoft Fabric allows us to share Semantic Models directly with external users as well, enabling entirely new…
-
Introduction Developing on Microsoft Power BI / Microsoft Fabric is adopting more and more engineering practices. Modern data teams find themselves looking towards solutions for collaborative development, version control and lifecycle management solutions. The GIT integration feature introduced to workspaces in Power BI / Fabric patches up many of the holes, and in combination with…
-
Introduction A Fabric feature which has flown a little under the radar (and which is still in Preview as of May 2024), is the ability to sync data from imported Semantic Models back to OneLake: Learn about Microsoft OneLake Delta table integration in Power BI and Microsoft Fabric – Power BI | Microsoft Learn The…
-
Introduction RLS in Microsoft Fabric is a convoluted topic which at the time of writing, is not very clearly spelled out for users. Most documentation refers to setting up RLS on Data Warehouses or Data Lakehouses by applying permissions directly on the tables: Row-level security in Fabric data warehousing – Microsoft Fabric | Microsoft Learn…
Downhill Data 