topic Re: Does the Report Server support custom connectors now in Report Server

Does the Report Server support custom connectors now

wyb — Mon, 26 Apr 2021 02:01:52 GMT

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 report to Power BI Report Server.

Re: Does the Report Server support custom connectors now

d_gosbell — Mon, 26 Apr 2021 04:23:43 GMT

No, I don't believe it does. There is a list of the supported data sources here https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

Re: Does the Report Server support custom connectors now

wyb — Mon, 26 Apr 2021 11:42:52 GMT

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?

Re: Does the Report Server support custom connectors now

d_gosbell — Mon, 26 Apr 2021 22:17:05 GMT

@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.

Re: Does the Report Server support custom connectors now

wyb — Tue, 27 Apr 2021 00:18:55 GMT

Thanks.

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

Re: Does the Report Server support custom connectors now

d_gosbell — Tue, 27 Apr 2021 01:22:06 GMT

@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.