Skip to the page
WISE Lensby AI WISE
Start free trial
All guides

All connections

Power BI, Tableau and BigQuery

One row per day, AI and question in your BI tool or warehouse, read with an API key. Each refresh is one call; once a day is plenty.

What you need

Plan
Every plan
Who
An Owner or a Member of your team. A Viewer reads only.
You need
Power BI Desktop, Tableau, or a Google Cloud project with BigQuery — and an API key.

Set it up

  1. In WISE Lens, open Connections › API keys › Create a key. Type what the key is for, then choose Make a key. Copy it now: it is shown once.
  2. Power BI Desktop: Get data › Web › Advanced. URL: https://aiseo.aiwise.sg/api/lens/v1/daily?format=csv. Header: Authorization, value Bearer <your key>. Sign in as Anonymous, then schedule a daily refresh.
  3. Tableau: connect to the Google Sheet the Google Sheets guide fills (Connect › Google Sheets), or download the daily CSV and connect to it as a Text file.
  4. BigQuery: run the two lines below once a day (Cloud Scheduler, a Cloud Run job or any server), with your key in WISELENS_KEY.
BigQuery
curl -sSf -H "Authorization: Bearer $WISELENS_KEY" "https://aiseo.aiwise.sg/api/lens/v1/daily?format=csv" -o wiselens_daily.csv
bq load --source_format=CSV --skip_leading_rows=1 --autodetect --replace your_dataset.wiselens_daily wiselens_daily.csv

When it works

The table's newest day is yesterday, and its Named matches WISE Lens's Overview.

If it does not work

Power BI asks how to sign in to the address
Choose Anonymous: the key travels in the header you added.
“this key is not known, or was revoked”
The key was revoked or mistyped. Make a new one and paste it again.
“this key is not whole”
Part of the key was lost in the copy. Copy it again, whole, from Connections › API keys.

Need help? Write to support@aiwise.sg and say which connection.

Turn it off

Connections › API keys › Manage keys › Revoke beside the key it uses. It stops at once.

Questions: support@aiwise.sg