Use WebAPI / JSON for Power BI Dashboards

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!


1 comment

Please sign in to leave a comment.