Updating Parameters for a Custom PowerBI Connector

[amitkar1980]

Hi,

I have created a Custom PowerBI connector which calls a Rest API with some parameters e.g.

1) URL

2) ObjectId

3) StartDate

4)EndDate

5) EntityIds ( optional)

The connector works well on powerBI desktop and also on PowerBI service. But it seems I have to create multiple versions of data sources for the same URL and ObjectId, to cater for users needing to report against different Start and End Dates. 

I tried to work around it yt adding startdate and enddate parameters to the datasets and mapping them to the connector parameters in PowerQuery. But  I get "Update Parameter Failed" everytime I change the dataset parameters and click apply . Also there is nothing in the gateway logs.

So, my question is is it by design that the data source definittion once created (with all required parameters) cannot be overwritten by dataset parameters or is a limitation of custom connectors at the moment? If so, is there a way around it

Cheers,

AK

[v-shex-msft]

HI @amitkar1980 ,

I'd like to suggest you add an optional parameter allow you to add contents to push to datasource, then you can do operate with these received optional contents on datasource side.
It should simple than setting and compare received records(into the custom connector) from datasource.
In addition, I'd like to suggest you post this to develop forums to get further support.

Regards,

Xiaoxin Sheng

[amitkar1980]

Hi ,

I tried that already. From my example, I had a parameter created for EntityIds (which is an optional connector parameter) and upon publishing, tried to update it. But it encountered the same error. So something tells me that tha dataset parameter change is not supported for custom connectors which is a big limitation.

As per your suggestion, I will post it in develop forum.

Cheers,

Amit