Data sharing / PowerBI integration

Requires data sharing service enabled for your tenant. If you don' have access to it, contact support@effect.io to get it enabled.

To be able to get the data into a PowerBI dashboard (or other Business intelligence software), you can enable this feature in the survey settings.

When the setting is enabled, a table is created and your tenant user will get access to this one automatically. 

How do I connect with PowerBI?

1. Enable the feature in survey settings
   
2. In PowerBI, go to "Add new data" and select Amazon Redshift as connector
   
3. Add the url (dataconnect.effect.io) and username / password (shown in survey settings)
   
4. Add username / password (shown in survey settings)
5. Select the data tables you want to use in the BI service, and next which type of connection you would use
   

How does it work?

1. When the data sharing feature is enabled, all existing data will be written to the data sharing table. This means that you don't need to have it enabled when beginning your projects
   
2. When feature is turned off, the table will be deleted automatically (other tables for other surveys will be kept)
   
3. If the tenant gets the feature turned off, all tables and the user will be deleted from the data sharing service.
   
4. Only completed respondents will appear in the data table
   
5. When a respondent completes, it will automatically be added to the survey table. This way you can have live update of respondents on your dashboard
   
6. When a respondent is deleted, it will immediately be deleted from the survey table, making the service always synched with the main survey database.
7. The service supports both import and DirectQuery. Learn more about DirectQuery here

Security

1. Connections are always encrypted
   
2. There is a strong password for the user, which can be reset in UI
3. Only surveys you select will be made available to the data sharing service
   
4. You can easily stop data sharing and delete the data in the data sharing by disabling the feature in survey settings
   
5. The data sharing service is completely separated from the main Effect IO database and data is only written to the service when you select it
6. The data is available to connect with on internet and is separate from the main Effect IO database

• Related Articles

• Data export

  To get raw data from a survey, the tenant admin can download a CSV file from surveys list. Click the download button on the right side of the survey row. The file will be downloaded directly. In the file you will find all completed responses. Where ...

• Javascript (JS) question - store and retrieve values

  The Javascript question is in itself not storing any data in the survey. To store and retrieve respondent actions, you need to implement the following code in your javascript To store data from javascript: ...

• Getting started as tenant admin

  Welcome as an Effect IO tenant administrator! Below you find an overview of the steps needed to go from a survey to exporting data. Effect IO is optimized for simplicity and flexibility for running projects. Working with surveys, reports and products ...

• About survey topics and topic groups

  A unique feature for the Effect IO software is how surveys and reports pages are defined as part of topics and topic groups. Topics and topic groups exists for multiple reasons. One of the reasons is that we really like standardization as it helps in ...

• Scales

  To simplify and centralize the scales used in surveys, Effect IO has a centralized scales features. When a scales is defined here, you will be able to reuse it across all surveys in your tenant installation. To get started, click the "Add new" button ...