Dear Edward,
we may not have the necessary Microsoft Power BI and Excel expertise to guide you through the process of creating a collaboration network.
What we did with GPI (for test purposes) is the following:
- Install Power BI desktop version and import from the internet the custom visual NetworkNavigator
- Download a GPI result list in XML format including publication numbers and applicant names
- Import the XML result list in Excel and transform it (create pivot table, use of Excel VLOOKUP function)
- Import the XLSX in Power BI desktop and use the XLSX columns to create a network of applicants:
We hope this information was of assistance to you.
GPI user support