cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wyb
Regular Visitor

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

1 ACCEPTED SOLUTION


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

View solution in original post

5 REPLIES 5
d_gosbell
Super User II
Super User II

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 

wyb
Regular Visitor

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?


@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

Thanks.

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


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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!