Adding endpoints to the Power BI Connector?

James Parsons

Does anyone know how to add an API end point to the Power BI connector, or if it's even possible?

I want to pull the Gift Code for our PowerBI reports, and this isn't available in the connector. I imagine there's some file in the Connector zip file that points to all the endpoints we can pull through it, and if that's the case it should be easy enough to add a line.

I could pull Gift Code through a query, queue, or Power Automate easily enough, but all of our reports focusing on gifts use the connector — I'd rather do it through that same source where possible.

Alex Wong

Custom connector is managed by the community, it can be updated, anyone can help with this as the code is on git

I don't know if there's instruction in git or not, so will benefit from reading it. Your custom connector also is likely outdated if you haven't been on git to download new one. So check there and see if the connector has already been updated with gift code.

James Parsons

Thanks, Alex! I'll take a look. It looks like it was last updated a few months ago, so I'll update our connector first.

Alex Wong

I believe I reported this problem before and don't remember if it was ever fixed. Gift Code only is returned for the "get a gift" api endpoint, even though list gift endpoint document this field being returned too, it is actually wrong. Either (1) documentation is buggy saying gift_code is returned but it is not, therefore fix the documentation or (2) code is buggy for list gift api endpoint that gift_code isn't being returned.

@Erik Leaver @Anthony Gallo can you please look into this?

James Parsons

To follow up: I was ablt to pull a new field (Gift Code) into the PowerBI connector, but there are only ever null values. In troubleshooting I put together a simple flow in Power Automate to pull this, and also only get null values. Is there something I need to do to access this endpoint?

James Parsons

Ah, thanks Alex! Glad to know that it's something with the API. I'll revert my change for now — but as a proof of concept it shows that I can change the connector's endpoints to add other data I'm looking for.