Question 1

Does TextQL understand my Power BI DAX measures?

Accepted Answer

Yes. TextQL reads your semantic model definitions, including all DAX measures, calculated columns, and table relationships. When you ask a question, Ana leverages these existing calculations rather than recreating them. This ensures answers are consistent with what your Power BI reports already show.

Question 2

Does TextQL work with Power BI Premium and Fabric?

Accepted Answer

Yes. TextQL supports Power BI Pro, Premium, and Premium Per User workspaces. It also works with Microsoft Fabric lakehouses and warehouses exposed through Power BI. The XMLA endpoint used for semantic model queries is available in Premium and Fabric capacities.

Question 3

What Power BI permissions does TextQL need?

Accepted Answer

TextQL needs an Azure AD service principal or user account with Viewer (or higher) access to the target workspaces and datasets. For XMLA-based queries, the dataset must be in a Premium or Fabric capacity. TextQL never requires admin or write permissions to your Power BI environment.

Question 4

Can I combine Power BI data with other sources?

Accepted Answer

Yes. TextQL can join Power BI dataset results with live queries against any connected data source — warehouses, databases, or other BI tools. Ask a question that correlates Power BI KPIs with raw database records and get a single, unified answer.

Question 5

Does TextQL respect Power BI row-level security?

Accepted Answer

Yes. TextQL queries execute through the authenticated user's or service principal's identity, and Power BI's RLS rules are fully enforced. Users only see data they're authorized to access. This means your existing security policies carry over to natural language queries without additional configuration.

Connect Power BI to Your AI Agent

Everything you need to know

Common questions

Connect to any of your other data sources

Bring Us Your Hardest Problem