Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Guru's ,
I am new to power BI community and want to learn more. Thought this is the right place to start...
Regarding Q&A feature, Have anyone used on live connection(on-premises) dataset? How is the performance? Would like to know how efficient it is for the business users?
We have not enabled the Q&A but just debting what value will it add to the business users.
Please share you experience and suggestions.
Thanks,
Siva
Hi there whilst it will work only with Live Connections, it does appear to say that there can be possible things that do not work as expected due to it having to index all the data and try and understand your data.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-q-and-a-direct-query/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-directquery-about/