Forum Discussion
mohsenvafa
Helper I
Helper IAsk a question about your data?
Hi I have published my report from PowerBI Descktop and created a dashboard. But 'Ask a question about your data' doesn't work. it keeps showing me the following message? We weren't able to load ...
If you are using direct query option for Azure SQL, then Q&A will not work. Please refer to below post.
https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
Habib
Continued Contributor
Continued ContributorWhat is your data source for your dashboard? Is it from on-prem or cloud.
mohsenvafaMy data come from a SQL Server in Azure. Is there any specific setting for that?- Habib
If you are using direct query option for Azure SQL, then Q&A will not work. Please refer to below post.
https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
- mohsenvafa
When I get my data in PowerBI descktop, I don't select the direct query option, but I write SQL Statmemt under Adavanced Option section. Is this considered as DirectQuery?