cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amitkar1980
Frequent Visitor

Updating Parameters for a Custom PowerBI Connector

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

2 REPLIES 2
Community Support
Community Support

Re: Updating Parameters for a Custom PowerBI Connector

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
amitkar1980
Frequent Visitor

Re: Updating Parameters for a Custom PowerBI Connector

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.