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

Q&A is not available for any of the datasets used on this dashboard

I am receiving this message when attempting to enable Q&A on my Dashboard. This was working previously when the dataset was linked to a sharepoint file. I since changed the setup to use OData instead. So my datatet now consists of 2 sources, 1 sharepoint CSV file and an OData query. Everything works fine in Power BI desktop. But when I publish it to Power BI Service, Q&A won't enable.

 

I didn't setup any RLS or Direct Query in the file (which was what I read about on this forum for this issue).

 

I am contemplating re-creating the .pbix file from scratch to eliminate the chance that there's some corruption caused by the changes I made to it. Might even drop and recreate the workspace as well. But obviously would prefer not to have to waste considerable time doing this if there's some other reason (eg. OData not support Q&A on Power BI Service??)

 

As I'm still on Power BI Pro trial I can't get any service from Microsoft so hope someone here can help.

1 ACCEPTED SOLUTION

Accepted Solutions
RoyceLithgo Frequent Visitor
Frequent Visitor

Re: Q&A is not available for any of the datasets used on this dashboard

I can answer this myself. After creating a new dashboard, you need to pin at least one visualisation from a report of your dataset to the dashboard. After that, the Q&A box automatically appears on the dashboard and you can use it to create additional visualisations for the dashboard (and you can delete the original pinned report visualisation to continue using Q&A to add additional visualisations to your dashboard).

 

View solution in original post

2 REPLIES 2
RoyceLithgo Frequent Visitor
Frequent Visitor

Re: Q&A is not available for any of the datasets used on this dashboard

I can answer this myself. After creating a new dashboard, you need to pin at least one visualisation from a report of your dataset to the dashboard. After that, the Q&A box automatically appears on the dashboard and you can use it to create additional visualisations for the dashboard (and you can delete the original pinned report visualisation to continue using Q&A to add additional visualisations to your dashboard).

 

View solution in original post

Jadnerb Frequent Visitor
Frequent Visitor

Re: Q&A is not available for any of the datasets used on this dashboard

This didn't work for me.  I have four tiles pinned and I still get the not available error

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 103 members 1,441 guests
Please welcome our newest community members: