Power BI Custom Connector

Hi  KeyurPatel14 

The requirements can be handled using the standard Power Query custom connector patterns, although there are some UI limitations.

• Filter dropdown: You can expose predefined filter values through a connector function parameter using Documentation.AllowedValues. This allows Power Query to present the values as a selection list, and the selected value can then be used to construct the OData $filter query. However, custom connectors don't provide a general framework for creating arbitrary UI controls.
  Back/re-selection: Custom connectors don't expose an API to add a custom Back button or control the Navigator's navigation flow. The recommended approach is to return a Navigation Table containing the available entities/tables. Users can then select the required entity from the Navigator rather than restarting the connection.

  Useful Links : https://learn.microsoft.com/en-us/power-query/handling-navigation-tables

  https://learn.microsoft.com/en-us/power-query/handling-resource-path

  https://learn.microsoft.com/en-us/power-query/samples-directory

   

  Hope this helps !!

  Thank You.