PowerBI Dashboards
PowerBI is Microsoft's comprehensive business intelligence and data visualization platform that empowers organizations to transform raw data into actionable insights. With its powerful data capabilities, PowerBI enables business users and analysts to create compelling visualizations, share reports across the organization, and make data-driven decisions without requiring extensive technical expertise. In this example, we'll show you how to leverage the Citizen Space Data API to create an interactive Site Overview Dashboard.
Quick Steps
Create an API key
Creating an API key is a fundamental step in securely connecting Citizen Space to external services. An API key serves as a unique identifier that authenticates your application ensuring that only authorised users can access your data. If you haven't already, the steps to do this are highlighted in the articles below:
Generating API keysOpen the Delib Site Overview template .pbit
Provided you have either Desktop PowerBI or Fabric you can open the pre-made Delib dashboard template. To get access please email apac@delib.net or your CSM. Once opened it will prompt you for your site URL and API key. The URL it is expecting needs to have the trailing API endpoint in the URL of /api/1/ for example: https://example.citizenspace.com/api/1/ As mentioned in the previous step the API key expected is the Base64 (key+secret) encoded version.
Check the Query Parameters
When you add in your Key and URL simply hit 'Load' and let PowerBI get to work. Provided your key and URL are correct you should be able to see a green tick next to 'Query Parameters' which indicates it has all the right information.
Depending on the number of activities, workspaces, and responses it could take a while to compile all this data together into an automated report.
Review your Site Overview Dashboard
Once everything has successfully loaded you will have an interactive Site Overview Dashboard.
Last updated