Set up a connection in Microsoft Power BI
Topics on this page
- Step 1: Open Power BI Desktop
- Step 2: Open ‘Retrieve data’
- Step 3: Select an OData feed
- Step 4: Paste the feed URL from 2ask
- Step 5: Set the authentication method
- Step 6: Select and load tables
- Step 7 (optional): Save or publish the report
- Use in the Power BI Service
- Troubleshooting
Using a Power BI/Tableau connection (OData feed) set up in 2ask, you can import survey results into Microsoft Power BI Desktop 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.
Note on authentication: 2ask uses the ‘Standard’ option in Power BI for OData access. Leave the username field blank; enter the password generated in 2ask as the password.
Step 1: Open Power BI Desktop
Launch Microsoft Power BI Desktop on your computer. These instructions apply to the current desktop version; menu labels may vary slightly depending on the language and version.
Step 2: Open ‘Retrieve data’
Go to the Home tab(or, in some versions, via File) and click on ‘Get Data’. A dialogue box will open, allowing you to select a data source.
Step 3: Select an OData feed
Look for the OData Feed connector in the list (often found under the ‘Other’ category) and click ‘Connect’.
Step 4: Paste the feed URL from 2ask
In the OData Feed dialogue box, paste the full feed URL from the 2ask connection (using the ‘Copy feed URL’ button). Ensure that the URL is complete and contains no spaces. Confirm by clicking OK.
Step 5: Set the authentication method
For authentication, select ‘Standard’ (or ‘Basic’ / ‘Username and password’, depending on the version).
Leave the username field blank. Enter the password displayed once in 2ask as your password.
Important: In the drop-down menu for the level at which this setting is saved, please select the bottom-most option (point 3 in the screenshot; the exact label may vary)
Confirm by clicking ‘Connect ’ or ‘Log in ’.
Step 6: Select and load tables
In the Navigator, 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
Select‘Load ’ or ‘Transform data ’.
Step 7 (optional): Save or publish the report
Once the tables have loaded, they will be available in the data pane. You can now create visualisations, save them as .pbix files or publish them to the Power BI Service.
Use in the Power BI Service
If you wish to publish the data in the Power BI service and would like it to be updated regularly, please refer to the developer documentation on ‘Daily deltas in the Power BI service ’.
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. Please also check under ‘File’ > ‘Options and Settings’ > ‘Data Source Settings’ to ensure the authorisation has been configured correctly. You can also delete the authorisation here and then set it up again. |
| Expected responses are missing |
Check the data scope in 2ask: completed or uncompleted 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. |





