Multiple Semantic Models for one Ontology Layer
Hello everyone, When generating an ontology layer, I see that you can generate one from a semantic model. However, I see I can import multiple warehouses and lakehouses as part of an ontology layer if I wanted to start from scratch. Let's say I have four semantic models that each represent an important busines process (finance, sales, inventory, production/procurement). Each semantic model follows a well-defined star schema, and are mature enough to even be considered data products. If I want to eventually create an agent where I access data from both sales and inventory semantic model, would the best practice be to import/use both semantic models in the ontology layer? Or should I create one ontology layer per semantic model, and have my agent consume the information by attaching both ontology layers to said agent? For this example, let's say I want an agent that can see sales history, customer purchasing behavior history from the sales model, and can see inventory of products being ordered fro the inventory model. Back to the original question, what's the best practice ultimately for an agent to consume information from multiple semantic models?
Fabric Data Agent: “Query cancelled” on aggregations
Good evening, I’m trying to build a Data Agent for my organization, even though the feature is still in preview. Its source is an ontology. I’m currently working with only six tables, but they are very large. I’m having an issue when asking the Data Agent questions that require grouping and aggregation, such as COUNT or SUM. In those cases, I often get the following error: "Query cancelled by upstream caller Status Code: Cancelled" The agent suggests that this may be caused by the amount of resources required by the query, which seems plausible. I also tried using smaller tables in the ontology. This improved things somewhat, and some queries now work, but aggregations are still extremely slow and I still frequently receive the same error. Is this expected behavior with large ontologies and aggregation queries, or could there be some configuration or setting that needs to be changed? Is there anything I can do to improve the performance of GROUP BY, COUNT, and SUM queries over an ontology-backed Data Agent? EDIT: I also found the following error in one of the question's execution log: 'The request was canceled due to the configured HttpClient.Timeout of 300 seconds elapsing.'From Data to Intelligence: How Fabric IQ Powers AI Agents
AI agents can help automation and insight - but without business context, they often fail. Enter Microsoft Fabric IQ, a new semantic intelligence layer that transforms Fabric from a data platform into an intelligence platform. Fabric IQ organizes enterprise data around business concepts, not tables, creating a shared ontology of entities, relationships, and rules linked to real-time data in OneLake. This enables AI agents to reason, interpret, and act with accuracy, eliminating the semantic fragmentation that causes unreliable decisions. In this session, we’ll: - Explain what Fabric IQ is and why it matters for AI adoption. - Show how its semantic layer powers agentic AI with examples. - Demo how an AI agent uses Fabric IQ to answer complex business questions. If you’re exploring AI agents or building intelligent apps, this session will show you how Fabric IQ provides the semantic foundation for trustworthy, context-aware automation.Build Business-Aware AI Agents
AI is only as good as the context it receives. Join Ahmed Salih and Aala Omer Taha for an in-person session exploring how Microsoft is enabling Business-Aware AI Agents through Microsoft IQ Platform, Fabric IQ, Data Agents, Semantic Models, Ontologies, Dataverse, Business Skills, and Copilot Studio. Learn how organizations can move from simply storing and analyzing data to building agents that understand business context, reason over trusted business knowledge, and help users take action. Store → See → Understand → Act Date: June 13, 2026 Time: 2:00 PM – 5:00 PM Venue: Espaces - Mohi Al Din, Dokki, Giza Seats are limited, so register early and join us on this exciting journey into the future of Business-Aware AI. Registration: Cairo In-Person Session Registration Copilot-Fabric IQ: Build Business-Aware AI Agent
Fabric Data Agent chat error: “The natural language query could not be processed” (Ontology source)
Hi all, I’m having a persistent issue with Fabric Data Agent when using an Ontology as the data source. In the chat, even very simple natural language questions fail with: “The request is invalid. The natural language query could not be processed. Please rephrase your query and try again.” RAID examples: db24d651-d4f8-4dd9-8fcb-bab105ee68eb, bfb8cd2a-676a-40a0-9c91-f36ca250ff07. What I already validated: Ontology and graph are created correctly. Relationships exist and are active. Manual graph queries execute successfully. The issue happens in chat NL queries (NL-to-GQL translation), even with minimal prompts. I recreated the Data Agent from scratch, same behavior. So this looks like a chat/NL parser issue rather than a data or graph execution issue. Has anyone found a reliable workaround, or is this a known service-side issue in preview? Any guidance from Microsoft team would be very helpful. Thanks!RLS not working in Fabric Plan, but works in the Power BI report
Hi, I have a semantic model in a Premium Capacity Workspace in Fabric where I'm just starting practicing how to build a Plan in Fabric. I created roles and assigned to users - I'm using my developer account and assigning to the users provided there -. The user Alex Wilber has Viewer role in the Workspace, is a member of the role for NA for RLS, and still can see all regions in the Plan, eventhough cannot see them in the Power BI report, there the RLS works just fine. Thanks in advance for your help! Cheers, FernandoFabric Plan writeback where dates and values have NULL
Hello, I finished my first exercise with Fabric Plan with a Planning Sheet where I forcasted 2026 based on the historical data from previous year in the semantic model with fake data, actually the semantic model demo provided by Lumel, called "transaction-dataset". I created a Fabric SQL Database and the corresponding connections to writeback the final Forecast. I clicked the Writeback button, finished, then went to the SQL Database and found the new table with data from the Forecast except for Year, Quarter, Month and Value, they all have NULL. Am I missing any configuration? Any help is greatly appreciated. Thanks, Fernandodata agent can't get data from ontology data source
Hello! I created an entity type in an ontology and successfully added a binding. The data is visible on the entity’s Instances page. However, when I use “Build agent with AI” to ask very simple questions about this ontology, it consistently returns a response similar to the one shown in the attached screenshot, referring to a “table” or "schema" As far as I understand, an ontology does not have the concept of tables. Is my understanding incorrect? Do I need to select or configure an ontology table somewhere before the agent can query the data? In addition, when I use "Test data agent" to query the ontology data, the request hangs for several minutes and then returns an error.Allocation failed: Can't perform this action, value cannot be distributed - in MIcrosoft Fabric Plan
Hello, I have a Planning Sheet with a Forecast column where I manually modified the forecast for specific product categories in the base forecast. When I try to change the value of those cells in the scenario, I get this error: "Allocation failed: Can't perform this action, value cannot be distributed." Thanks for any advice. Cheers, Fernando
