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 all,
I am using a custom connector that queries my database via DirectQuery (database is InterSystems IRIS). Everything works fine in Desktop mode but once I publish the report I am getting the below error trying to access it. I do have the on-premise gateway installed.
Any ideas?
Thanks,
-- Alex
DirectQuery error: DirectQuery may not be used with this data source - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version.
Hi there,
yes, the test connection of the gateway is successful. My database isn't SQL Server so those cumulative fixes/updates don't apply in my case.
Thanks,
-- Alex
Hi @alxschaefer ,
Have you configured gateway on the service,and test connection successful,pls check it.
And pls refer the below and check if it is helpful.
Best Regards
Lucien