Power BI / Tableau (OData feed) - Create the connection in 2ask
Topics on this page
- Prerequisites
- Open the data connection in 2ask
- Configure connection
- Integration with your BI tool
- Safety and Operating Instructions
Guidance on making survey results available to external BI tools via an OData feed.
Prerequisites
- Access to the relevant survey project in 2ask and the authorisation to manage the results and data connections.
- Microsoft Power BI Desktop, Tableau or another tool that supports OData feeds.
- A secure location for the feed URL and the associated password.
Open the data connection in 2ask
In 2ask, open the survey project you want and go to:
Results > Data Connection
The ‘Data Connection’ page displays the available integrations. Under ‘Power BI / Tableau’, select the ‘Add connection’ option. In the dialogue box that appears, enter a meaningful name for the connection and click ‘Next’.
Configure connection
Generate access credentials
In the ‘Access details for Power BI’ section, you will find the feed URL. This URL is the OData endpoint for your connection.
- Copy the feed URL displayed by clicking ‘COPY FEED URL’.
- Click ‘GENERATE PASSWORD’ to generate a password for accessing the feed.
- Save the password immediately and securely. For security reasons, it is only displayed in full once.
- The feed cannot be accessed without the password. Only share the URL and password with authorised persons or systems.
Important: Treat the feed URL and password as login credentials. Do not include the password in publicly accessible reports, tickets or documents
Define data scope
In the ‘Data scope’ section, you specify which questionnaires and which format of response output are to be made available via the feed.
Select the combination that suits your analysis requirements. This selection determines which data the BI application can later retrieve via the feed.
Save settings
Click ‘SAVE’ at the bottom to apply the configuration. Click ‘CLOSE’ to exit the view. The connection can then be accessed and edited again in the ‘Data Connection’ overview.
Integration with your BI tool
The links below provide instructions for various integrations:
- Set up a connection in Microsoft Power BI
- Setting up a connection in Tableau
- Setting up a connection in Microsoft Excel
Safety and Operating Instructions
- Only share the feed URL and password with people who need access to the survey data.
- Store the password in a suitable password manager or a shared secret/credential store.
- Take particular care to protect personal or confidential information in unencoded response texts.
- If access details have been disclosed or access is no longer required, reset the password in 2ask and update the BI connection.





