Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. November 2023

Semantic Link: OneLake integrated Semantic Models

Semantic Link adds support for the recently released OneLake integrated semantic models! You can now directly access data using your semantic model’s name via OneLake using the read_table function and the new mode parameter set to onelake. This approach ensures that no load is placed on Analysis Services, enabling efficient data retrieval and avoids putting additional load on your Power BI capacity.

Optimized access of OneLake integrated semantic models

When using the onelake mode, the data is read directly from the delta tables in OneLake, which are kept up to date with the semantic model. This enables seamless access to the data for various data consumers without the need for additional ETL pipelines or data copying. Here’s a code snippet using the read_table function with onelake mode to read the customer table in the Adventure Works semantic model:

Programmatic export of data can be triggered using the new execute_tmsl function. This Python function allows you to run Tabular Model Scripting Language (TMSL) commands to export the data from your semantic model. Please note that XMLA read/write needs to be enabled for the semantic model.

Here’s a code snippet for triggering the programmatic export using the execute_tmsl:

Don’t miss out on the power of semantic link in Microsoft Fabric! Leverage the seamless integration between semantic models and Synapse Data Science to unlock the full potential of your data.

Related blog posts

Semantic Link: OneLake integrated Semantic Models

Blog's featured image

Building Custom AI Applications with Microsoft Fabric: Implementing Retrieval Augmented Generation for Enhanced Language Models
June 26, 2024 by Amir Jafari

We are excited to share guidance for how you can use Microsoft Fabric to turn your data into knowledge for Generative AI applications. This guide will walk you through implementing a RAG (Retrieval Augmented Generation) system in Microsoft Fabric using Azure OpenAI and Azure AI Search. By the end, you’ll be more familiar with how to … Continue reading “Building Custom AI Applications with Microsoft Fabric: Implementing Retrieval Augmented Generation for Enhanced Language Models”

Read more
Blog's featured image

Introducing Capacity Pools for Data Engineering and Data Science in Microsoft Fabric
June 25, 2024 by Santhosh Kumar Ravindran

We are excited to announce the Capacity Pools for Data Engineering and Data Science in Microsoft Fabric. As part of the Data Engineering and Science settings in the Admin portal, capacity administrators can create custom pools based on their workload requirements. Optimizing Cloud Spend and Managing Compute Resources In enterprise environments, managing cloud spending and … Continue reading “Introducing Capacity Pools for Data Engineering and Data Science in Microsoft Fabric”

Read more