TRENDING

TECHNOLOGY NEWS FROM AROUND THE WORLD

→
Enterprise AI with RAG and Power BI semantic models: route each question to the right data
Artificial Intelligence · 2026
Artificial Intelligence

Enterprise AI with RAG and Power BI semantic models: route each question to the right data

Separate document retrieval from numerical analytics and preserve semantic definitions, data permissions, and source lineage when answering business questions.

Yazılımcının GünlüğüPublished: Nov 16, 20266 min read
JOIN THE DISCUSSION
✎ Write a comment
Reading progress0%

Not every business question is a RAG question

Finding which version of a procedure is in force is a document retrieval problem. Calculating how net sales changed by product group last quarter is a numerical analytics problem. Forcing both into vector search can produce plausible answers that ignore metric definitions. First classify whether a question needs documents, structured data, or both.

The semantic model is the business metric dictionary

A Power BI semantic model can centralize measures, relationships, dimensions, and security rules. The AI layer should use approved measures and dimensions rather than generating arbitrary SQL against random tables. If net sales, active customer, and production efficiency have one definition, natural-language answers follow the same business rules across reports. Semantic-model quality bounds answer accuracy.

Machine learning pipelineConceptual sketch · summary of the article's technical flow

RAG retrieves document context without bypassing access controls

A RAG pipeline chunks documents, creates embeddings, retrieves relevant passages, and supplies them as model context. Preserve source identity, version, access scope, and last update time for every chunk. Apply user permissions before retrieval or in a trusted filtering layer. Putting an unauthorized document in the prompt and asking the model not to reveal it is not a security control.

Conceptual architecture: Enterprise AI with RAG and Power BI semantic models: route each question to the right data

Tool calls and SQL generation must be constrained

If AI needs to query a semantic model or run SQL, do not send free text directly to a database. Define allowed measures and dimensions, limit query scope, validate parameters, and preserve the caller's identity. Result sets must not expose personal or confidential fields. The model should see only data the user can access, and tool calls should leave auditable logs.

Show evidence and uncertainty

Showing which document version or semantic measure supports an answer improves trust. Explain data freshness, filters, period, and metric definitions. When no source is found, the model should limit its answer rather than fill the gap with a guess. Production evaluation must test query correctness, permissions, source accuracy, and calculated results—not only fluent language.

Test model answers against evidence

Fluent output is not proof of accuracy. Define the data available to a model, its permissions, tools and failure behavior. Evaluate stale documents, conflicting sources, denied requests and missing retrieval results, not just simple examples. Keep citations and version identifiers so an output can be audited later.

Operate with cost, privacy and rollback in mind

Context length, retrieval, caching, tool calls and retries influence the true cost of an AI application. Avoid sending private data unnecessarily to external providers. Set clear logging retention and human review paths. Compare a new version against a stable test set and preserve a rollback route for incorrect automated actions.

Be the first reader ✎ Write a comment

Comments

No comments yet. Be the first to contribute.

Try the comment interactions · demo preview

The two examples below are only a UI demo, not real visitor comments. Likes and replies are local to this page and are not saved; use the real form below to post.

Demo participant ADEMO · TEST

I'd like to see which steps benefit most in real deployment.

Demo participant BDEMO · TEST

An example test scenario would make the technical analysis clearer.

✎ Write a comment

Your first and last name will appear publicly alongside your comment.