Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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).
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).
This didn't work for me. I have four tiles pinned and I still get the not available error