Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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