SQL server enterprise gateway natural language que...

philjames · ‎03-03-2016

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?

asocorro · ‎03-03-2016

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 · ‎03-03-2016

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

GuyInACube · ‎03-03-2016

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 | Azure Data / Fabric CAT
@GuyInACube | youtube.com/guyinacube