There are two ways to connect Microsoft data:
- Sign in — default. Each person connects their Microsoft work account. Rivvi sees SharePoint, OneDrive, Excel, Outlook, and Power BI that account can already open.
- Advanced org-wide app — you register an Azure app and paste its credentials under Settings → Connectors → Microsoft 365 → Advanced. Use this only if you need unattended, app-identity access.
Option A — Sign in (default)
1
An admin enables Microsoft 365
Settings → Connectors → Microsoft 365 → Enable. If you’re not an admin, click Request.
2
Each teammate signs in
Under Your account, click Connect and sign in with a Microsoft work or school account. Approve access and you land back connected.
3
Enable Power BI (if you'll use it)
Power BI still needs the tenant setting below if you use an org-wide app. Per-user sign-in uses that person’s Power BI access.
Option B — Advanced org-wide Azure app
Register your own Entra (Azure AD) application and paste three values into Rivvi. This uses the OAuth 2.0 client-credentials (service principal) flow — an app identity, not a user login.1. Register the app
1
Create the app registration
In the Microsoft Entra admin center → App registrations → New registration. Give it a name (e.g. Rivvi Connector). Account type Single tenant is fine. No redirect URI is needed for the client-credentials flow.
2
Copy the IDs
On the app’s Overview, copy the Directory (tenant) ID and the Application (client) ID.
3
Create a client secret
Certificates & secrets → New client secret. Copy the secret Value immediately — it’s shown only once.
2. Grant Microsoft Graph permissions
Add Application permissions (not Delegated) under API permissions → Add a permission → Microsoft Graph → Application permissions:
Then click Grant admin consent for <your org>. Each permission should show a green “Granted” state.
3. Paste into Rivvi
1
Open Advanced
Settings → Connectors → Microsoft 365 → Advanced (or connect Power BI on its own inside that same tile).
2
Enter your three values
3
Connect
Rivvi verifies the app can reach Microsoft before marking it connected — so a wrong secret or missing permission fails now, not on the first question.
Enable Power BI access
Power BI is the one exception to the “sign in and you’re done” story when you use an app identity. Microsoft gates the Power BI REST API behind a separate tenant setting that neither admin consent nor Graph permissions can turn on. This is a one-time, tenant-wide step done by a Power BI administrator.1
Turn on service-principal API access
In the Power BI admin portal → Tenant settings → Developer settings → “Allow service principals to use Power BI APIs.” Enable it — for the whole organization, or for a security group that contains Rivvi’s app (its service principal).
2
Add the app to your workspaces
A service principal can’t see a workspace until it’s a member. In each Power BI workspace Rivvi should read: Workspace → Manage access → Add the app (or its security group) as a Member or Admin.Granting the tenant setting org-wide exposes every workspace automatically; adding per-workspace gives you tighter control.
Multiple Power BI workspaces
Rivvi works across every workspace your app can access — not just one. Different workspaces often carry different sensitivity levels (a clinical workspace vs. a marketing one), and Rivvi treats each independently.- Discover them — Rivvi can list every workspace the app is a member of.
- Read across all of them — asking for “my reports” spans all your workspaces; each report is tagged with the workspace it came from.
- Target one — you (or the agent) can scope a question to a specific workspace by name.
- Pin a default (optional) — set a Default workspace ID when connecting so ambiguous questions land on your primary workspace. Leave it blank to always work across all of them.
Row-level security (RLS) and SSO
A Power BI dataset with row-level security or single sign-on (SSO) can’t be queried by an app identity — that’s a Microsoft platform limit, not a Rivvi one. If the agent hits one, it tells you plainly instead of returning a partial, filtered result. Query a dataset without RLS/SSO, or point Rivvi at the underlying data source.Troubleshooting
“Couldn't verify credentials” when connecting (org-wide app)
“Couldn't verify credentials” when connecting (org-wide app)
Usually a mistyped client secret (copy the Value, not the Secret ID), a wrong tenant ID, or admin consent not yet granted on the Graph permissions. Re-check API permissions show a green “Granted” state.
Connected, but no Power BI workspaces show up
Connected, but no Power BI workspaces show up
The tenant setting “Allow service principals to use Power BI APIs” isn’t enabled, or the app isn’t a member of any workspace. See Enable Power BI access.
A specific Power BI workspace is missing
A specific Power BI workspace is missing
The app isn’t a member of that workspace. Add it under Workspace → Manage access as a Member or Admin.
A dataset query fails with a row-level security message
A dataset query fails with a row-level security message
That dataset has RLS or SSO enabled, which an app identity can’t query. Use a dataset without RLS/SSO, or query the underlying source.
Security notes
- Rivvi’s default Microsoft path is your signed-in account. The agent can only open what that account can already open.
- The only Power BI actions that change anything — refreshing a dataset, exporting a report — are write capabilities that ask for your approval every time. See Permissions.
- With an org-wide app, your app’s secret is stored securely for your organization and never shown back to you. Disconnecting removes it.
- You can revoke Rivvi’s access any time: disconnect in Rivvi, and (for an org-wide app) remove the app under Enterprise applications in Entra.