Forum Discussion

wyb's avatar
wyb
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's avatar
    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.

wyb's avatar
wyb
Regular Visitor
5 years ago

Thanks for your reply.

I have already connect a new data source in Power BI Desktop using a custom odbc connector that supports DirectQuery. 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?

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper 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's avatar
    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's avatar
      d_gosbell
      Icon for Super User rankSuper 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.