Excel settings for power queries

Power queries provide an alternate way to access BioNet data. We have a number of refreshable Excel spreadsheets that contain embedded power queries that enable you to extract data directly from BioNet databases.

Issue

Some users are presented with this error message upon opening a pre-existing power query.

Excel settings for Power Queries, Figure 1 Error message

Figure 1 Error message

Solution

Follow these steps to resolve this issue:

  1. In Excel, go to File > Options > Trust Centre > Trust Centre Settings > External Content
  2. Make sure the security settings for Data Connections, Workbook Links, and Linked Data types are set to 'Prompt user …'
  3. Click 'Ok'

Excel settings for Power Queries, Figure 2 Security settings screen

Figure 2 Security settings screen

  1. Reopen the power query to apply the security setting changes.
  2. Remember to refresh the power query as required by clicking 'Enable Content' and 'Refresh All'.

Excel settings for Power Queries, Figure 3 Refresh All tab

Figure 3 Refresh All tab

More information

All BioNet power queries are available via our BioNet resources page.

For further assistance, please contact the BioNet team bionet@environment.nsw.gov.au