PowerBI Swagger found on Github causing issues when using it to create Custom Connector in Power

[UncleMartin]

Hi there,

I have a potentially silly question: has anybody experience with the PowerBI Swagger on Microsoft Github? Particularly at https://github.com/microsoft/PowerBI-CSharp/tree/master/sdk/swaggers

I want to use that to create a Custom Connector in Power Platform - to be used by Power Automate, since the built-in connector has only very limited functionality and seems to be out-of-date feature-wise.

The problem I have is that when creating a Power Platform custom connector in the Admin portal, I receive the error feedback, that the swagger has more than 256 actions and hence can't be used (in fact it has 276 actions).

All attempts to surgically remove 20+ actions from the Swagger have failed, and I'm nearing the end of my wits... 😞

Is that the right swagger? Is there a better suitable one for Power Automate?

Any help is highly appreciated! Thx.

[Anonymous]

Hi @UncleMartin ,

Please review the following blog, hope it can help you achieve your requirement.

Power BI + Power Automate API Connector

---

I did not have issues with this one: https://github.com/microsoft/powerbi-rest-api-specs/blob/master/swagger.json

To import from an OpenAPI / swagger file, follow the directions here: https://docs.microsoft.com/en-us/connectors/custom-connectors/define-openapi-definition

By far, this is the best article to follow on configuring your Power BI Custom Connector (after importing from swagger/OpenAPI file): https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33

---

Best Regards

[UncleMartin]

OK, so after some further searching I found yet another swagger definition on Github here https://github.com/dataxbi/powerbi-api-swagger.

The difference to the previous one seems to be ~50 lesser actions - and after some tweaking (nope, was not working out-of-the-box) I finally was able to create the custom connector... tests are pending.

Still, I would like to know if someone here was able to get the original Microsoft Swagger to work?

Thanks.