Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mohsenvafa
Helper I
Helper I

Ask 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 suggestions right now. Please try again later.

 

What could be a reason for that?

1 ACCEPTED SOLUTION
Habib
Responsive Resident
Responsive Resident

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/

 

 

View solution in original post

8 REPLIES 8
Habib
Responsive Resident
Responsive Resident

What is your data source for your dashboard? Is it from on-prem or cloud.

My data come from a SQL Server in Azure. Is there any specific setting for that?
Habib
Responsive Resident
Responsive Resident

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/

 

 

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?

Anonymous
Not applicable

Can we hide/remove the "Ask a question about your data" feature from the dashboard?

Anonymous
Not applicable

Hi, I have the same question. I would like to remove that bar from there. 

Anonymous
Not applicable

Hello Apoorvu,

 

Please go to the right top corner of your dashboard  -> ' more options' ->'Settings' , then disable the Q&A.

 

Let me know if this answers your question.

Regards,

Anonymous
Not applicable

Thank you so much! It worked

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.