Path: Community Topbar >> Apps icon >> Community Settings >> Integration >> All Apps >> Power BI
Power BI is a Business Analytics tool created by Microsoft, where customers can create their own custom reports.
Community Administrators can now connect their IdeaScale community with the Power BI Desktop app to create an impactful analysis of their community data with Power BI custom visualizations by installing and setting up the connector from All Apps.
Before signing in to IdeaScale Analytics, the admin must have an Ideascale account with administrator permissions (email address/password) within the Ideascale community they want to connect with the Power BI.
Power BI Setup
-
Click on the Connect button to set up Power BI for the community.
-
Click on the Manage button in order to Generate Connector Package. This will allow you to download the connector package and setup PowerBi for this Ideascale community.
3. Download the Ideascale Analytics Installer to set up in your computer. 
4. Complete the installation using the setup.exe file and add it in your apps. 
Once the setup is complete and installed you will now be able to see it in Apps section in your machine.
Connect to IdeaScale Analytics data from Power BI Desktop app
Once the administrator has the Power BI Desktop app opened they will see the below page:
1. Select Get Data from the Home ribbon in Power BI Desktop. Select Other from the categories on the left nav, select IdeaScale Analytics (Beta), and then click on Connect button.
2. To sign in to the IdeaScale Analytics account, click on the Sign in button. 
3. This will take the admin to their IdeaScale login page. Enter the Ideascale credentials which are email address and password for login or Single Sign-On (if enabled on a community level).
5. Once successfully signed in, click the Connect button.
6. Once the connection is established, the administrator will be taken to the Navigator section in Power BI. Close the Navigator. Refresh to get the latest report for the community or you can choose to Edit or run a new query from the right side panel. 
- To create Custom Report, the community administrator will have to transform data of each desired field on the Navigator section, which may be necessary for the custom report.
- To use a preloaded report created by IdeaScale, simply open the IdeaScaleAnalytics_v1.12.pbix.
Limitations
Following are the limitations associated with accessing IdeaScale Analytics data.
-
IdeaScale Analytics has a built-in limit of 1K rows returned per API call.
-
Only IdeaScale community administrators can access the API.
-
If the OAuth token is expired then the API call will throw a relevant error message.
-
If the community administrator is locked or the community is blocked for some reason, then the API call will throw a relevant error message.
-
We currently do not support Social Login.
To learn more about Power BI tables and their associated fields: Power BI Field Explained.