Forum Discussion

theblueslover's avatar
theblueslover
Frequent Visitor
4 years ago

Oauth2 authentication not available when OData source URL is added filters

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      theblueslover
      Frequent Visitor
      4 years ago

      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.