Forum Discussion

Regular Visitor

5 years ago

Solved

Does the Report Server support custom connectors now

Hi, does the Report Server support custom connectors now? When I use Desktop version 2021.1 to save report to the Report Server, an error is reported. An error occurred while attempting to save the...

custom connector

d_gosbell
5 years ago
wyb wrote:

I want to use DirectQuery to connect to the data source, but most of them do not support DirectQuery in Report Server.

This is true, Report Server only supports a small number of the more common data sources like the popular relational databases for Direct Query. But this is a known, documented product limitation - you could try posting a request on https://ideas.powerbi.com for this functionality to be expanded for your specific datasource.

d_gosbell

Super User

5 years ago

wyb wrote:

If the Report Server does not support custom connectors, how can new data source be used in Report Server and use DirectQuery like Oracle Database?

So there is a huge list of supported data connectors in the link I posted and both ODBC and Oracle are on that list. You don't need to build custom connectors to connect to either of those types of data sources.

wyb

Regular Visitor

5 years ago

Thanks.

I want to use DirectQuery to connect to the data source, but most of them do not support DirectQuery in Report Server.

d_gosbell
Super User
5 years ago
wyb wrote:

I want to use DirectQuery to connect to the data source, but most of them do not support DirectQuery in Report Server.

This is true, Report Server only supports a small number of the more common data sources like the popular relational databases for Direct Query. But this is a known, documented product limitation - you could try posting a request on https://ideas.powerbi.com for this functionality to be expanded for your specific datasource.