Embiro BI

Documentation › Troubleshooting

Common problems

Fixes for the problems Embiro BI users meet most - signing in, connecting databases, Google Sheets authorization, charts with no data, missing dashboards and emails.

Signing in

"Use your organization's address to sign in"
You're on app.embirobi.com. Sign in at your organization's address, such as https://your-company.embirobi.com. Don't know it? Click Don't know your organization's address? Email it to me. See Your address and signing in.
"Invalid login" though the password is right
Check you're at the right organization's address: you can only sign in where you are a member. If SSO is enforced, use Sign in with SSO.
The reset email doesn't arrive
Check spam and promotions folders for mail from no-reply@embirobi.com, and that you typed the email your account uses. Then ask your Super Admin or an Admin to send a temporary password.
The invitation link doesn't work
Invitations expire after 7 days and work once. Ask for a new invitation.

Connecting a database

The connection times out
A firewall is blocking Embiro BI. Allow 13.49.213.196 on the database port, or use an SSH tunnel. See Firewalls and SSH tunnels.
"The host resolves to a private or internal address"
Embiro BI can't connect to localhost or private network addresses. Use the database's public address, or an SSH tunnel through a public jump host.
"password authentication failed" / "Access denied for user"
Wrong username or password. For Supabase's pooler, the username is postgres.<project-ref>. In a SQLAlchemy URI, URL-encode special characters in the password.
"SSL connection is required"
Switch on SSL in the connection form, or add ?sslmode=require to a PostgreSQL URI.
"Your plan allows N data connections"
You're at your plan's limit. See Connections per plan.

Google Sheets

"Authorization needed" keeps coming back
Edit the connection → Advanced → Security → tick Impersonate logged in user. See Google Sheets.
The list of tabs is empty
The connection address must be gsheets:/// followed by the encoded sheet URL cut at /edit. Rebuild it with the box on the Google Sheets page.
Numbers show as text, or sums are empty
Format the column as numbers in Google Sheets and remove text such as "UGX" or "N/A" from number cells.

Charts

"No results were returned for this query"
The filters or time range exclude every row. Set Time range to No filter to check, then narrow down. Also check the dataset's Default datetime column is the date you expect.
The chart shows old numbers
Results are cached for an hour. Use Force refresh. See Caching and refreshing data.
A time chart has no date to choose
Mark the date column Is temporal in the dataset's Columns. If dates are stored as text, set its Datetime format, or add a calculated column that converts it.
A map is empty or missing districts
The map needs ISO codes such as UG-102, not names. Newer Ugandan districts need mapping to their parent district. See Maps and ISO codes.

Dashboards and access

A colleague can't see a dashboard
Check it's Published, and that a group gives them every dataset it uses.
A Business User has no download option
Exports are off for Business Users. See Export controls.
"This page isn't included in your plan"
The feature belongs to a higher plan. See Plans and features.

Reports and emails

A report email didn't arrive
Check spam, then Settings → Alerts & Reports → the report → Execution log for the error. Check the report is Active.

Still stuck?

Contact us with what you were doing, the time, your organization's address, and any error code. Error codes are explained on Error codes.

Something unclear or missing? Tell us and we'll improve this page.