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

Highlighted
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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors