live wire
▸ThoughtSpot makes Spotter 3 default for new instances; it requires download rights and always shares query data with an LLMThoughtSpot documentation▸MotherDuck adds image classification and object location to prompt_jev(), returning typed SQL outputs with confidence scoresMotherDuck▸BigQuery conversational analytics adds Montréal and Toronto; mixed-region agents still default to globalGoogle Cloud Documentation▸Fabric enables Azure OpenAI Copilot access by default, but OpenAI-subprocessor and cross-region processing/storage switches remain offMicrosoft Learn▸Snowflake Cortex Agents now continue by default when named tools are inaccessible, emitting warnings instead of failing the runSnowflake documentation▸Databricks Genie One can use group memberships to tailor answers, while Unity Catalog remains the access-control boundaryDatabricks documentation▸Fabric data agents can query Power BI models with Read alone; Build and workspace access are unnecessaryMicrosoft Learn▸Fabric data-agent Git configs expose column flags, but selecting a table still includes every columnMicrosoft Learn▸Google Data Agent Kit offers remote Spark kernels, but notebook exports can still move results into local Pandas or ArrowGoogle Cloud Documentation▸Cube says production analytics agents need explicit partial-result states, caller-filtered model search and durable artifactsCube▸Thinking Machines names Bridgewater behind ReViSQL-K2.6, citing 92.97% SC-16 accuracy at 15% of frontier-model costThinking Machines Lab▸AWS says a mismatched data/tool/prompt release cut its Field Sales agent pass rate from 78% to 38% in pre-productionAWS Artificial Intelligence Blog▸NL2SQL Multi-Agent ships evaluation artifacts across BIRD, CSpider, Archer and KDD DataSpace—but no software licenseGitHub▸Snowflake says Cortex Analyst apps keep working, but recommends Cortex Agents; semantic views and verified queries carry overSnowflake Documentation▸ThoughtSpot makes Spotter 3 default for new instances; it requires download rights and always shares query data with an LLMThoughtSpot documentation▸MotherDuck adds image classification and object location to prompt_jev(), returning typed SQL outputs with confidence scoresMotherDuck▸BigQuery conversational analytics adds Montréal and Toronto; mixed-region agents still default to globalGoogle Cloud Documentation▸Fabric enables Azure OpenAI Copilot access by default, but OpenAI-subprocessor and cross-region processing/storage switches remain offMicrosoft Learn▸Snowflake Cortex Agents now continue by default when named tools are inaccessible, emitting warnings instead of failing the runSnowflake documentation▸Databricks Genie One can use group memberships to tailor answers, while Unity Catalog remains the access-control boundaryDatabricks documentation▸Fabric data agents can query Power BI models with Read alone; Build and workspace access are unnecessaryMicrosoft Learn▸Fabric data-agent Git configs expose column flags, but selecting a table still includes every columnMicrosoft Learn▸Google Data Agent Kit offers remote Spark kernels, but notebook exports can still move results into local Pandas or ArrowGoogle Cloud Documentation▸Cube says production analytics agents need explicit partial-result states, caller-filtered model search and durable artifactsCube▸Thinking Machines names Bridgewater behind ReViSQL-K2.6, citing 92.97% SC-16 accuracy at 15% of frontier-model costThinking Machines Lab▸AWS says a mismatched data/tool/prompt release cut its Field Sales agent pass rate from 78% to 38% in pre-productionAWS Artificial Intelligence Blog▸NL2SQL Multi-Agent ships evaluation artifacts across BIRD, CSpider, Archer and KDD DataSpace—but no software licenseGitHub▸Snowflake says Cortex Analyst apps keep working, but recommends Cortex Agents; semantic views and verified queries carry overSnowflake Documentation
nl2sql.ai
guideAccess control

A Fabric data agent can bypass your workspace roster—because Power BI Read permission is enough

Microsoft’s sharing model means an agent user can query a semantic model without Build permission or workspace membership. Review item-level grants, not just workspace roles.

Power BI Read can allow agent queries without workspace membership.
Side by side: what changed
By The News Desk· Oct 17, 2026the quick take — two AI hosts go live when you do

Microsoft’s Fabric data-agent documentation draws a boundary that is easy to miss during an access review: a person can query a Power BI semantic model through a data agent with Read permission alone. They do not need Build permission, and they do not need access to the workspace that contains the model. Row-level and column-level security still apply, but the workspace member list is therefore not a complete inventory of who can ask the model questions.

The agent has two permission gates

Sharing the agent and sharing the data are separate operations. Microsoft says recipients need access to the Fabric data agent and to its underlying sources. For Power BI semantic models, the minimum effective source permission is Read. For other supported sources, the documented floor varies: lakehouses require item-level Read plus table access where enforced; warehouses require Read or SELECT on the relevant tables; KQL databases require the Reader role; and ontologies require access both to the ontology and to the source bound beneath it.

That distinction creates a practical troubleshooting rule. A user may be able to open the agent but still receive authorization errors or empty results when a question touches a source they cannot read. Conversely, a user absent from the workspace roster can still receive answers if the agent and semantic model were shared directly with them.

Audit the effective reader set

For operators, the useful unit of review is not “who is in the workspace?” It is the intersection of three sets: people who can use the published agent, people who have Read access to each connected model or source, and people who pass the source’s row- and column-level policies. That is the population capable of getting an answer.

This also argues against granting Build merely to make an agent work. Microsoft says Build or Write remains necessary for model changes and capabilities such as Prep for AI, but not for queries initiated through a Fabric data agent. Least-privilege deployments should therefore separate consumers, who need Read, from builders, who need broader rights.

Published and draft access are different

The agent itself has another useful boundary. Publishing creates a read-only version that can be shared while its draft continues to change independently. A recipient with the default sharing permission can query only the published version and cannot inspect its configuration. “View details” exposes both published and draft configurations without edit rights; “Edit and view details” permits changes to both.

The operational checklist is short: inventory direct Read grants on every connected semantic model, verify source-specific permissions beyond Power BI, test row- and column-level policy outcomes with representative users, and keep Build or workspace membership reserved for people who actually author. If an access review looks only at workspace roles, it is reviewing the wrong boundary.

Filed by The News Desk. Corrections: desk@nl2sql.ai · Our standards →

comments · 0

    Comments are moderated before they appear. Your email is used once to confirm it is you — never shown, never sold. Corrections and questions get an answer from the desk when we have one.