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

Enabling Q&A on Direct Query SQL Server 2014 data

Hello All,

 

I have been looking for a solution for this issue on the forum for a couple of days now. I have created a couple of reports along with connected Dashboards and published them on the PowerBI service through an Enterprise Gateway connection. The data source is a local SQL Server 2014 instance on my computer connected through Direct Query. The data source is connected and working as expected on the report and the dashboard. However when trying to enable the Q&A, it does not allow me to enable it for the data source.

 

Below is the outcome when I try to enable Q&A on the dataset.

Untitled.png

 

 Any help here would be much appreciated !

 

Thanks,

Premdas

 

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Enabling Q&A on Direct Query SQL Server 2014 data

Hi @premdask,

I test the scenario as yours and get the same issue. 

As stated in this article, currently, the Q&A for Direct Query feature is only available for SQL Server 2016 Analysis Services data sources.  Moreover, the Q&A for Direct Query feature is still in preview and additional data sources supported by the enterprise gateway will be rolled out during the public preview. You can also submit an idea here about your issue.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
premdask
Frequent Visitor

Re: Enabling Q&A on Direct Query SQL Server 2014 data

Thanks for the response Lydia, I had seen this article before posting here. However noted that the article was from July 2016 so was not sure if the information on the article was still current!

 

Thanks,

Premdas

Moderator v-yuezhe-msft
Moderator

Re: Enabling Q&A on Direct Query SQL Server 2014 data

Hi @premdask,

The information on the article is still current. And you can submit an idea about your issue.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications