I would like to create a PowerBI dashboard so executives can visualize our Crisis Mgt teams by site from a Business Continuity Dashboard. Our team members are tagged on the user Profile with a combination of customer fields and attributes. That excludes the use of a simple user or group export (with excel integration) to see all the fields required to query for a 'complete' CMT team view.
The Person method gets me all I need (along with User Device if I want basic contact info), but since I've never used the API directly before, let alone with Power BI, I'm wondering if anyone else in the community has any advice or samples around authentication (either basic or OAuth), paging and general gotchas with Power BI integration.
Thanks in advance and I'll be sure to share my experience on this thread!
Comments
Please sign in to leave a comment.
Hi Rachael,
I am definitely an xMatters xPert, and not familiar with PowerBI. That said, I did a little googling and found out that it looks like a Custom Connector may be the best way to go about this.
Microsoft published a DataConnectors github repository here (Data Connector SDK and samples for Power Query and Power BI) that explains the technique (uses M language).
I also found a more sophisticated example created by Blackbaud for accessing their Sky API from PowerBI. It may provide a good reference for techniques to use. That github repository is here.
Wish I could provide more guidance, but perhaps some other community members may be able to chime in.
If you decide to try the Data Connector route, feel free to ask question here with respect to how our OAuth works, or pagination, etc.
Hope that helps!