PartnerCenter Analytics for MS Power BI
We are all aware of the PowerBI capabilities, well most of us are :)
"Power BI (PBI) is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards". This is a short guide for utilising this powerful tool for MS Partner Center Analytics (PCA):
1. Install Power BI if you don't already have it:
https://app.powerbi.com/getdata/services/partneranalytics?cpcode=PartnerCenterAnalytics&getDataForceConnect=true&alwaysPromptForContentProviderCreds=tr
2. Create yourself a Power BI account if you don't already have it. You can use any email of your choice to register.
3. Set or Verify the Authentication method is oAuth2
4. Login with your Partner Center admin credentials to authenticate PBI for PCA and Accept.
5. Once connected, data will begin to sync and load, can take upto 15 minutes.
6. Once data has finished loading, you can view different features. MS Article explains it well:
https://msdn.microsoft.com/en-us/partner-center/power-bi-app-for-direct-partners-use
Points to note:
1. For PCA in PBI, you need to be a diretc partner in MS CSP Program.
2. You need to be admin / global admin / billing admin for your compan's AAD.