cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philjames Frequent Visitor
Frequent Visitor

SQL server enterprise gateway natural language query

the Natural Language Query search box does not show up for a dashboard that is backed by an On Prem SQL Server using the Entrprise Gateway. How do I get this to show?

3 REPLIES 3
asocorro Member
Member

Re: SQL server enterprise gateway natural language query

You can't.  It's like that by design.  I assume it's because Power BI needs the data to have been loaded, and with DQ it is not.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
philjames Frequent Visitor
Frequent Visitor

Re: SQL server enterprise gateway natural language query

Ugh! Is it supported by SQL Azure or SSAS on prem?

Moderator GuyInACube
Moderator

Re: SQL server enterprise gateway natural language query

Q&A/Natural Language Search will only work when data is imported into the Power BI Service. If it is using a live connection (AS) or DirectQuery, Q&A won't be available.

 

Basically, it either needs to be one of the SaaS Content Packs, or imported into Power BI Desktop/Excel and then published to Power BI for Q&A to be available.

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube