Forum Discussion
PowerBI Swagger found on Github causing issues when using it to create Custom Connector in Power
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.
2 Replies
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.
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
