Fabric Semantic Link and Use Cases
One of my top three favorite features in Microsoft Fabric
Power BI
Fabric🚀Lightening Fast Copy In Fabric Notebook
Enhance productivity in Fabric Notebook using mssparkutils' fastcp, a Python wrapper for azcopy, providing 9x faster file copying
Flatten Nested JSON in Microsoft Fabric
🚀 Using notebooks in #MicrosoftFabric: Whenever technology advances for citizen #PowerBI developers, it’s impossible for me not to pay attention! I’m thrilled to share how recent improv…
Announcing: Column-Level & Row-Level Security for Fabric Warehouse & SQL Endpoint | Microsoft Fabric Blog | Microsoft Fabric
We are excited to announce the availability of Column-Level and Row-Level Security in Fabric Warehouse & SQL Endpoint in Public preview in all regions! In today’s data-driven world, organizations are constantly collecting vast amounts of sensitive information that fuels their operations, decision-making processes, and competitive edge. While data accessibility is essential for business success, ensuring …
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-column-level-row-level-security-for-fabric-warehouse-sql-endpoint/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Announcing: Column-Level &amp; Row-Level Security for Fabric Warehouse &amp; SQL Endpoint&#8221;</span></a>
YOUR NEW ACTION HERO! What is Data Activator? — Advancing Analytics
Meet your new favourite action hero, Data Activator. It’s the newest experience to be added to Microsoft’s unified Software-as-a-Service (SaaS) platform Fabric, having been made available in the public preview at the beginning of October.
But what is it? What does it do? How can you use it?
Measure Maze: Visualizing Measure Dependencies Using Semantic Link & Network Analysis
Introducing MeasureMaze: a Python library for enhanced Power BI measure dependency visualization, network analysis, and workflow optimization
Power BI Desktop project report folder - Power BI
Learn about the Power BI Desktop project report folder.
Enterprise / DevOpsPower BI Desktop project dataset folder - Power BI
Learn about the Power BI Desktop project dataset folder.
Overview of Fabric deployment pipelines - Microsoft Fabric
An introduction to deployment pipelines the Fabric Application lifecycle management (ALM) tool
Git integration with Power BI Desktop projects - Power BI
Learn about Git integration with Power BI Desktop. projects.
Best practices for lifecycle management in Fabric - Microsoft Fabric
Learn about the best practices for Git integration and deployment pipelines in the Microsoft Fabric lifecycle management tool.
Lineage in Fabric - Microsoft Fabric
Learn how to view the lineage of Fabric items.
Lifecycle management tutorial - Microsoft Fabric
Understand the workflow of using Git integration with deployment pipelines to manage the lifecycle of your apps.
Reduce Support Costs with Business Assist Forecast Service Excel Add-in
Business Assist Forecast is a tool that enables quick and confident forecasting of future support volume based on historical data, which can save time compared..
PowerApps
7 DAX Golden Rules You Must Not Ignore - Goodly
In this blog, I will share 7 golden rules for writing DAX formulas that will help you create more sophisticated and effective calculations.
DAX
Building and growing a diverse team
This is my personal blog, but a lot of what I post here is informed by my work at Microsoft, filtered through the lens of my personal reflection. For the past two and a half years my work has inclu…
Getting report visual IDs with Power BI Desktop Developer Mode
Link visual IDs found in Log Analytics to visuals in a Power BI report
Deep dive into the Model Explorer with calculation group authoring and creating relationships in the properties pane
The model view now has even more to offer! We are excited to share the public preview of the Model explorer in the model view of Power BI Desktop.
Chat your data in Microsoft Fabric with Semantic Kernel | Microsoft Fabric Blog | Microsoft Fabric
Using Microsoft Fabric&#8217;s Lakehouse we can manage different data sources. Today Microsoft Copilot is very popular, and we hope that Microsoft Fabric can become an indispensable part of enterprise data management and make it easier for enterprise data to connect with LLM. This blog will combines data engineering and data science perspectives to construct Copilot &hellip;
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/chat-your-data-in-microsoft-fabric-with-semantic-kernel/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Chat your data in Microsoft Fabric with Semantic Kernel&#8221;</span></a>
Enabling granular access control for all data connection types
The foundation of centralized connection management is granular access control. Power BI always enforces granular access control for shareable cloud connections (SCCs). For all other data connection types, it can be enabled at the tenant, workspace, and dataset level.
Deployment pipelines &#8211; A customized pipeline is finally here!
You asked, we deliver! The option to create a customized pipeline of 2-10 stages is now available. Check it out!
How to use Tableau with Power BI and Fabric — DATA GOBLINS
In this post, I’ll explain the how and why of: How to connect Tableau to Power BI semantic models. How to connect Tableau to Fabric lakehouses (and other items that have a SQL endpoint).
Tableau - like Power BI - can be used to make interactive visualizations with different data sources. If you or your organization use both Power BI and Tableau, you might be confronted with scenarios where you want to make a Tableau dashboard from a published Power BI semantic model.
I'm attempting to be objective in my language and information, but my work and articles focus on Power BI. As such, my text might include unintentional biases towards Power BI. Don't consider any opinions or statements below as bona fide facts or promoting one product over another.
You can rename fields: In the Tableau workbook, you can rename fields (dimensions and measures) to other names. This has no effect on the Power BI dataset; Tableau is not doing a write operation.You can create calculated fields: In Tableau, it’s possible to create additional calculations using the dimensions and measures in the Power BI semantic model, already. These are effectively the same as thin-report measures in Power BI. It isn’t possible to create columns.
A Power BI semantic model (formerly a dataset) is often a key, central component in a reporting ecosystem. The semantic model typically contains important business logic in the table structures, relationships and measures. These are used in central reports that deliver insights to data consumers in the business. However, self-service users can also connect to a semantic model to perform their own analyses. This is valuable, as they re-use the logic defined in the semantic model to answer additional questions and address new use-cases. These self-service analyses can be done in a variety of client tools; users aren’t just limited to Power BI Desktop. This flexibility helps users get the most of their Power BI datasets with their skills and tools of choice, and without needing to copy data or rebuild existing logic.
Maximising Data Value with Microsoft Fabric: Data Lineage and Impact Analysis
Table of Contents Introduction to Data Lineage With more emphasis on data management and governance than ever before, understanding the journey of data from its source to its destination is […]
Fabulous Stuff in Fabric – Part 1: Cloning Tables | Under the kover of business intelligence
A while ago I had a little blog post series about cool stuff in Snowflake. I'm starting up a similar series, but this time for Microsoft Fabric. I'm not going to cover the basic of Fabric, hundreds of bloggers have already done that. I'm going to cover little bits & pieces that I find interesting,
Case-sensitive models in Power BI: consequences & considerations — DATA GOBLINS
In this short article, we look at the consequences of having a case-specific collation in your Power BI semantic model. This is particularly important as Direct Lake models created in the Fabric user experience have a case-sensitive collation applied, automatically.
Fabric: Lakehouse or Data Warehouse?
There are 2 kinds of companies currently active in the Microsoft data space: those who are migrating to Microsoft Fabric, and those who will soon be planning their migration to Microsoft Fabric. 😅 One question that often comes back is
Should I focus on the Lakehouse or the Data Warehouse?
Let’s answer that in this post. I can already tell you this: you’re asking the wrong question 😉
OneLake file explorer: easy access to open workspaces and items online | Microsoft Fabric Blog | Microsoft Fabric
With the latest OneLake file explorer v1.0.10.0 (download here), you can now seamlessly transition from browsing your OneLake data in Windows File Explorer to accessing&nbsp;it in the online Fabric portal.&nbsp; Perhaps you are using OneLake file explorer to upload data that you want to analyze in a Fabric Notebook.&nbsp; After uploading the data, you can &hellip;
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/onelake-file-explorer-easy-access-to-open-workspaces-and-items-online/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;OneLake file explorer: easy access to open workspaces and items online&#8221;</span></a>
Fabric Change the Game: Exploring the data | Microsoft Fabric Blog | Microsoft Fabric
Microsoft Fabric offers a set of different tools to explore and prepare the data for analysis and from that perspective, notebooks have become one of the quickest ways to get started with data exploration. This post draws its inspiration from the world of experimentation, exploration, and seamless integration into Microsoft Fabric- Data Science in Microsoft &hellip;
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-change-the-game-exploring-the-data/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Fabric Change the Game: Exploring the data&#8221;</span></a>