How to Find Live Connect Data From a Questionnaire to Use in a Chart
Enterprise Users will be able to view and interact with pages. Performance Managers/Modellers can edit pages and objects, and Model Administrators have full permissions.
You will still need to check your personal permissions to access this area with your site Administrator.
To modify a page, you must have report builder access or above to open designer mode.
Live connect data can be used from several sources including questionnaire forms and text files like .csv that have been saved into the system.
When using the power query editor, select a new source, and click on “Live Data”.
Then click on the “Click to Select” and then find your data source.
Connecting to data from a questionnaire
Typically, a live connection to a questionnaire form like the Incident LFPSE form or an audit will have a suffix of “(Questions as Columns)” that is how you can distinguish between questionnaire data, and everything else.
When you click to select your data, use the search to try and find the connection you wish to use.