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

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

UncleMartin — Thu, 09 Jun 2022 21:15:21 GMT

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.

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

UncleMartin — Thu, 09 Jun 2022 22:32:56 GMT

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.

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

Anonymous — Tue, 14 Jun 2022 08:33:53 GMT

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