Blog

  • Row Level Security in Microsoft Fabric – Update: No need for Tabular Editor!

    Introduction In March, I wrote about How to setup RLS in Microsoft Fabric / Power BI without breaking DirectLake functionality – Downhill Data (downhill-data.com) Back then, RLS was not possible to edit through the Web Authoring experience of Semantic Models in Fabric. Instead, you had to go the roundabout way of using Tabular Edit to…

    Read more

  • My Experience and top tips for the Fabric Analytics Engineer Associate Certification (DP-600)

    If you want to showcase your Microsoft Fabric prowess, DP-600 is the certification you are looking for. With a syllabus covering data analytics, data engineering, platform management and enterprise development best practices, it is indeed a test worthy of Analytics Engineers. Personally, I felt this was the hardest Microsoft Exam I’ve taken to date, due…

    Read more

  • Send Data Driven notifications by SMS/Teams/Slack with Data Activator and Power Automate on real time eventstreams in Microsoft Fabric

    Introduction Real Time Analytics in Microsoft Fabric is flying a little under the radar, which is a shame, because the benefits are huge. Especially, if you start putting real time data into the hands of the people who need to react to it. And especially, especially if you do so at the right time. Introducing:…

    Read more

  • Low-Code Real Time Data in Microsoft Fabric w. Eventstream & KQL Database

    Introduction “I want the data in real time” – is a sentence heard once too many by Data Analysts. In reality, real time has many different definitions depending on the stakeholder. To some it means that data is updated once an hour. To some it just means updated data ‘when I get in in the…

    Read more

  • Fabric for Data Analysts – Acting on data with Data Activator

    Introduction While Microsoft Fabric promises a collaborative workspace for Data Analysts, Engineers and Scientists alike, the person with the most to gain, and the least to lose, from the data mesh-like architectural patterns in Fabric is the Data Analyst. Do you, as a Data Analyst, recognize any of the following challenges? Then Microsoft Fabric might…

    Read more

  • Fabric for Data Analysts Consuming and Reporting

    Introduction While Microsoft Fabric promises a collaborative workspace for Data Analysts, Engineers and Scientists alike, the person with the most to gain, and the least to lose, from the data mesh-like architectural patterns in Fabric is the Data Analyst. Do you, as a Data Analyst, recognize any of the following challenges? Then Microsoft Fabric might…

    Read more

  • Fabric for Data Analysts – Data Storage & Serving

    Introduction While Microsoft Fabric promises a collaborative workspace for Data Analysts, Engineers and Scientists alike, the person with the most to gain, and the least to lose, from the data mesh-like architectural patterns in Fabric is the Data Analyst. Do you, as a Data Analyst, recognize any of the following challenges? Then Microsoft Fabric might…

    Read more

  • Fabric for Data Analysts Part 1: Data Ingestion & Preparation

    Introduction While Microsoft Fabric promises a collaborative workspace for Data Analysts, Engineers and Scientists alike, the person with the most to gain, and the least to lose, from the data mesh-like architectural patterns in Fabric is the Data Analyst. Do you, as a Data Analyst, recognize any of the following challenges? Then Microsoft Fabric might…

    Read more

  • How to setup RLS in Microsoft Fabric / Power BI without breaking DirectLake functionality

    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…

    Read more

  • How to create Measure Tables in Microsoft Fabric

    Creating Measure Tables in Microsoft Fabric Semantic Models Measure Tables have long been used to store Measures in Power BI Semantic Models. However, in Microsoft Fabric, where most of the data modeling takes place in the browser, at least if we wish to reap the benefits of the DirectLake storage mode, the process of creating…

    Read more

Hi, I’m Jon.

I blog about Microsoft Fabric, Power BI, Power Apps & Power Automate, and speak at conferences about data, business intelligence and data driven decision making.

Subscribe below to avoid missing out on the latest guides and articles!

Blog at WordPress.com.