All guides
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
- 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.
- 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.
- 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.
- BigQuery: run the two lines below once a day (Cloud Scheduler, a Cloud Run job or any server), with your key in WISELENS_KEY.
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.csvWhen 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