Microsoft Fabric use case
Microsoft Fabric lakehouse and warehouse questions in your own words
Ask Microsoft Fabric questions in Claude, ChatGPT or Copilot: gold lakehouse tables, warehouse facts and semantic model measures, under Entra ID sign-in.
Short answer
Microsoft Fabric lakehouse questions with Nexatron mean asking in your own words, from the Nexatron app or from Claude, ChatGPT and Copilot, against gold lakehouse tables, warehouse facts, mirrored databases and semantic model measures. Microsoft Fabric is available, with user-level access: Nexatron inherits existing Microsoft Fabric permissions.
Example questions
- What were net sales by store and week this quarter from the gold sales tables in the lakehouse?
- How did inventory days on hand change by product category over the last six months?
- Which customers’ open orders in the mirrored ERP database are past their promised ship date?
- What is gross margin by region using the margin measure in the finance semantic model?
- How many device events per minute did the eventhouse ingest during last night’s peak?
Agree these definitions first
- Which layer
- Gold tables only, or silver tables too, for each subject area.
- Measure or column
- A DAX measure in a semantic model, or a column summed in the warehouse: they can disagree.
- Freshness
- When a table, mirror or semantic model was last refreshed.
- Calendar
- The date table and fiscal calendar the answer uses.
How it works
1. Connect Microsoft Fabric
An administrator connects Microsoft Fabric to your Nexatron workspace with Microsoft Entra ID OAuth 2.0, reading lakehouse and warehouse SQL endpoints, KQL databases, and semantic models through the Power BI executeQueries API.
2. Permissions
Users sign in with their own Microsoft Entra ID account, and Nexatron inherits their Fabric workspace roles and item permissions, which decide which lakehouses, warehouses and models an answer reads.
3. Agree the definitions
Data owners approve the definitions above once, so a sales figure means the same thing in a report and in a chat answer.
4. What each answer shows
Questions only read Microsoft Fabric. When a word such as “sales” or “margin” has more than one meaning, the answer says which reading it used and offers the others in one click. It reads Verified only once a named person on your team has reviewed the logic, with who and when shown. A question Nexatron cannot answer under your rules is declined, with the reason and what to do next.
5. Ask where your team works
People ask in the Nexatron app or through Nexatron’s hosted MCP server in Claude, ChatGPT and Microsoft Copilot. Each answer shows the definition, source and query it used.
Try it on your own Microsoft Fabric data
Bring the questions above, or your own, and the report you compare against today. Do not include credentials or confidential records.