Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Super User

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 

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.

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.