Forum Discussion
Report won't display using DirectQuery
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.
- Activity IDb25dc6d8-0291-47f7-861e-1165d45dc4be
- Request ID0712d705-1207-0b74-ec9d-41b90c0cbc74
- Correlation ID8b2a2034-cb3c-3973-36e7-e15e70e00a08
- TimeMon Oct 03 2022 10:56:19 GMT-0400 (Eastern Daylight Time)
- Service version13.0.19226.35
- Client version2210.1.13426-train
- Cluster URIhttps://wabi-us-north-central-h-primary-redirect.analysis.windows.net/
2 Replies
- v-luwang-msft
Community Support
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
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
