Oauth2 authentication not available when OData source URL is added filters

[theblueslover]

When I add the table name to the OData source URL (the one that I use to get all the tables to select from) my query directly returns that particular table. After I publish my report to Power BI service, I no longer see OAuth2 available in the authentication method which prevents me from scheduling refresh.

The reason I add the table name is to apply filtering to the source.

I would highly appreciate any help.

Thank you

[Anonymous]

Hi @theblueslover ,

For custom connectors to work with the on-premises data gateway, they need to implement a “TestConnection” section in the custom connector’s code.

The method for implementing TestConnection functionality is likely to change while the Power BI Custom Data Connector functionality is in preview.

For more details, please check this document.

https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport 

Best Regards,

Jay

[theblueslover]

Thank you for your reply. The data I'm retrieving is on-cloud and when I do not add any filters to the OData url I can authenticate using OAuth2 and schedule refresh without any on-premise data gateway.

Would there be any other options that I should take into consideration?

Thank you.