Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have been using Q &A visual in a report for a report using Direct Query connection to Azure Analysis Services. It has been working well until this morning when I got the following error messages:
Q and A is turned on the Dataset in Power BI Service so I don't get why this is happening.
Many Thanks
HisPhil
Hi, @HisPhil ;
You could try to Enable Q&A, and can see the following article about Q&A restrictions, compare whether to check your own report.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-q-and-a-direct-query
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @HisPhil ,
That error message give quite a few reasons why this might not be working. I understand that it HAS been working, but with the June updates for Power BI Desktop, Gateway and Server and with the potential of a change in your SQL Server have you confirmed that each of these circumstances listed is not affecting you?
Proud to be a Datanaut!
Private message me for consulting or training needs.
Thanks Collin. I am still on May 2021 release and this was working on May 2021 release so there's no change of environment. The data source is Azure Analysis Service by Direct Query too. I got this up and running last week.