Interested in using your Identity Security Cloud data with Microsoft’s PowerBI? Yannick will show you how to create a Custom Connector for PowerBI leveraging Identity Security Cloud’s APsI to create appealing dashboards for your business.
What is the benefit of building a custom connector rather than using the Power BI as built functions for Web Connectors to use the API end points for reporting? It was reIatively easy to create the connection and adjust the power query to pull paginated records. did that and it works great… but would like to understand why building a custom connector is a better solution?
That’s a good question.
At the end of the day, both are written in M.
It’s probably more a matter of packaging.
The custom connector approach is perhaps better for reusability as you can have parameters, and secured credentials.
I’m not good enough in PowerBI to write “functions” like I did to support pagination for instance, but that may be doable directly in a PowerBI file.
At the end of the day, what is doable in both approach is:
Call REST Endpoints
Support OAuth
Have typed data (so you don’t have to do it each time)