Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I connected my powerbi dashboard to an underlying Azure sql database. However, the Q&A option in settings displays a message
'Q&A is not available for any of the datasets used on this dashboard' .
Is this a known issue? Any workaround to get the Q&A to work with direct connection to azure sql. ?
Solved! Go to Solution.
I am getting exact same issue not using any direct query.
I have tried with Excel sheet
Also
uploaded model via power bi desktop without any connections to try Q& A getting same issue.
Anyone else found any work around ??
Please reference these articles for more information.
Q&A in Power BI
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-q-and-a/
How to use Power BI Q&A
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-how-to-use-q-and-a/
Enable Q&A for Direct Query (Preview)
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-q-and-a-direct-query/
Section from article - Enable Q&A for Direct Query (Preview)
During the Preview phase of this feature, there are several limitations:
Initially the feature is only available for SQL Server 2016 Analysis Services data sources. The feature is optimized to work with tabular data. Some functionality is available for multi-dimensional data sources, but the full Q&A experience is not yet supported for this dataset type. Additional data sources supported by the enterprise gateway will be rolled out during the public preview.
Full support for row level security defined in the SQL Server Analysis Services is not available initially in the public preview. While asking questions in Q&A, the “auto-complete” of questions while typing can show string values a user does not have access to. However, RLS defined in the model is respected for report and chart visuals so no underlying numerical data can be exposed. Options to control this behavior will be released in coming updates.
Q&A does not work with Power BI Gateway-Personal data sources.
Thank for the answer but it does not solve my problem.
Like I said before, I'm not using direct query and I'm not using RLS. I'm using Excel files and the option for Q&A isn't available for this particular dataset while it is available for other datasets that I have.
I do not find any answer to this particular case in what you suggest.
Can you think of any other possible reason?
Thanks.
I have the same problem
I'm not using Direct Query.
I'm not using RLS.
So, what could be the problem?
Hi,
I'm geting this same issue and my data source is a folder of CSV files on my laptop so not using Direct Query. I'm sure it worked earlier!
Thanks
Rishi
Hi I had the same problem with an Access DataBase, the problem was that I had a role created so the Q&A is disabled because in Q&A sequrity roles are not avaiables....
I hapo it helps 😉
I have the same message and I'm using a .pbix file on premise. What could possibly cause the error message?