cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trevb
Resolver I
Resolver I

Cortana & Q&A on a dataset missing

When I first started using PowerBI there was a free text query on the dashboards.  It was interesting but not primary for me.  Today I decided to try it again, but it was missing.  I soon figured out that it could be turned on for the dashboard but when I did so I was told that none of my datasets were suitable.

 

I went into PowerBI settings looking for the datasets and the one I wanted to use is completely missing the Cortana and Q&A option.  It stops after scheduled refresh, so no chance to turn on there.

 

I don't believe this is anything to do with not having a gateway as all of my sources are coming from Project Online so it is all in cloud accessible data.  There are no Access, SQL, Excel data sheets anywhere just one database from Project online and a bunch of queries to reformat the data therein to make it useful for me.

 

I'm now stumped, can anyone tell me why I am not able to activate this anylonger?

 

Many thanks.

1 ACCEPTED SOLUTION
trevb
Resolver I
Resolver I

And now I answer my own question for future people referencing this.

 

At some point a while ago I had noticed the role level security and had a play.  It had not done what I wanted so I ceased to use it but I did not remove the row level security group defined.

 

Currently Cortana and Q&A are not compatible with Role level security and thus they were disabled.  Deleting the roles from Power BI desktop and republishing made the options available again  🙂  All sorted

View solution in original post

3 REPLIES 3
beatnikthedan
New Member

This isn't working for me and I have no Roles setup on my dataset. Anyone have any other ideas?

trevb
Resolver I
Resolver I

And now I answer my own question for future people referencing this.

 

At some point a while ago I had noticed the role level security and had a play.  It had not done what I wanted so I ceased to use it but I did not remove the row level security group defined.

 

Currently Cortana and Q&A are not compatible with Role level security and thus they were disabled.  Deleting the roles from Power BI desktop and republishing made the options available again  🙂  All sorted

View solution in original post

Hello

 

Do you know if this is still an issues? I am struggling to get the Q&A options to appear while RLS is enabled on my dataset 😞 .

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors