Has anyone connected Powerbi to the pureCloud APIs for reporting?
Hello Robert.
Not yet, but planning to.
You might wanna start by checking out the AppFoundry for an existing connector. Keep in mind the fair API use policy and that there are specific API's designed for analytics that might even process data in a async fashion.
** API fair usage **
Analytics API
https://developer.genesys.cloud/analyticsdatamanagement/analytics/
AppFoundry:
https://appfoundry.genesys.com/filter/genesyscloud/listing/61a3411b-22c6-4b5d-b1f5-ee8162578541
https://appfoundry.genesys.com/filter/genesyscloud/listing/78f998d6-c46b-479f-9e4f-fdfc34d62762
https://appfoundry.genesys.com/filter/genesyscloud/listing/30febd59-960b-447b-8c7b-328c429c2564
We have had several custom projects and have packaged IP where we use Power BI to present information from the GC APIs.
However, we pull data down first and deposit into an Azure SQL Server (most the time) or other historical repository based on customer needs and cloud providers. From there, we'll create Power BI reports from that DB in question.
You can hook up Power BI directly to the APIs I believe. But to Daniel's point, and depending on how you deploy the Power BI report, it would be a pretty good way to burn up your fair usage.
If you create a Direct Query report with Power BI pointed at the GC API suite, then deploy that report for your user base, I'm confident the API query throttling would come into play and your fair usage would go through the roof.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.