Custom Data Connector - Filter Selector

eramirez · ‎09-25-2017

Hi,

I'm building a Custom Data Connector for Power BI, and I want to have two selectors and one to be affected for the first selection, like Select Country and then City.

Right now I have a restul service that when I send a country it returns all the cities from that country, How can I achieve calling the service with an on change or some event of the selector.

Here is my code where I Create the selectors:

//Set AllowedValues on each parameter
AddAllowedValues =
let
    AvailableCountries = getDataFromUrl,
    AvailableCities = {},
    CountryParamType = type text 
                      meta [Documentation.AllowedValues = AvailableCountries],
    CityParamType = type text 
                      meta [Documentation.AllowedValues = AvailableCities],
    NewFunctionType = type function (
                       Select as CountryParamType,
                       Select2 as CityParamType2) 
                       as table,
    CastToType = Value.ReplaceType(BaseFunction, NewFunctionType)
in
    CastToType
 
in
    AddAllowedValues;

I hope you can help me

Regards