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 ashttps://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
localhostor 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=requireto 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.