Set up a connection in Tableau

Using a Power BI/Tableau connection (OData feed) set up in 2ask, you can import survey results into Tableau and build reports and dashboards based on them.

Prerequisite: The feed URL and password must already have been set up in 2ask (see Power BI / Tableau (OData feed) – Creating a connection in 2ask). The feed cannot be accessed without a generated password.

Step 1: Open Tableau Desktop or the web version

Launch Tableau Desktop on your computer or open it in your browser. These instructions apply to the current web version; menu labels may vary slightly depending on the language and version.

Step 2: Add a new data source

From the ‘New’ menu, select ‘Published data source’. A dialogue box will open, allowing you to select a data source.

Step 3: Select an OData feed

In the ‘Connectors’ category, search for the OData connector and select it.

Step 4: Enter the feed URL and password from 2ask

In the dialogue box, paste the full feed URL from the 2ask connection (using the ‘Copy feed URL’ button). Ensure the URL is complete and contains no spaces. Confirm by clicking OK.

For authentication, select ‘Username and password’.

Enter ‘odata’ as the username. Enter the one-off password displayed in 2ask as the password.

Confirm by clicking Log in.

Step 5: Select and load tables

In the left-hand pane, you can select the tables you wish to import:

  • Responses – actual participants
  • PretestResponses – participants from pre-tests or the preview function
  • ValueLabels – coding scheme with labels for the codes

To do this, click on a table and drag it into the right-hand pane.

Step 6: Import table(s)

Depending on your requirements, you can now either ‘Create an extract’ (1) to load the table in full, or publish the data source, for example to make it available to your team.

Troubleshooting

Error Solution
Unable to retrieve feed

Has a password been generated? Has it been entered correctly? Is the full feed URL being used?

Login fails Use ‘Standard’ authentication; in Power BI, leave the username field blank and enter the 2ask password.
Expected responses are missing

Check the data scope in 2ask: completed or incomplete questionnaires, as well as coded or uncoded output.

Password is no longer known

Open the connection in 2ask and – if necessary – generate a new password. Then update the saved login details in the BI tool.

Do you find this article helpful?