Custom Data Connector with OAuth2 in Power BI Service

[pudaludalu]

Hi,

I have a custom data connector with OAuth2 authentication that I want to use in Power BI Service as a template app and then publish to Azure Marketplace. Can anyone tell me if it is possible at the moment? If so, how would I do that?

Thanks!

[v-shex-msft]

HI @pudaludalu,

As Gilbert said, current custom connector is managed on gateway, you can't directly use it without other requirements.

For your requirement, I'd like to suggest you use web and other connectors with rest API(mixed known connectors) to get data and return records to power bi instead of custom connectors. (notice: integration credentials verify into power query steps, then you can use anonymous authorization in power bi service side)

OAuth2 REST API as data source 
Regards,

Xiaoxin Sheng

[GilbertQ]

Hi there

As far as I know I am not sure if it is supported for Custom Data Connectors because the Connector needs to installed on a Gateway.

Here are more details on Template Apps https://docs.microsoft.com/en-us/power-bi/service-template-apps-overview

[pudaludalu]

Hi Gilbert,

Thanks for the reply. If I can get the Connector installed on the Gateway, am I able to publish the template app to Marketplace? The Microsoft document doesn't seem to mention these. Thanks!

[GilbertQ]

Hi there

Thinking about it logically, when a customer installs the Template App, they would then need to configure the Custom Connector on their Gateway to enable them to query the data?

[pudaludalu]

Hi Gilbert,

I want the users to install and use the Power BI App from Marketplace without having to configure anything, is it possible to do that with the custom connector?

[GilbertQ]

Hi there

I do not think it is possible, because the Custom Connector has to be installed on a Gateway.

[pudaludalu]

Is there another way to make it work? Basically I want to publish a Power BI app in Marketplace that uses a custom connector. 

[GilbertQ]

Hi there

As far as I am aware there is no way to get it done