How do I connect Weever to Power BI with SSO?

Connect to your Weever Forms and Weever Inspections data through our OData connection to make real time reports.

In Power BI desktop, follow these steps to connect your Weever data to Power BI and make reports. 

Step 1 - Add your OData URL

If you want to connect to your Weever Forms Data: 

Tap "Integrations" from the menu in Weever and then tap the "Copy oData Feed URL to clipboard" button. 

Screen Shot 2021-06-04 at 2.08.44 PM

This URL will connect you to these tables: 

Form Submission Tables "User" Table "DatabaseItem" Table
Tables include: all fields in the form 

Table includes: all users in User Management in Weever Forms

Columns included: 

▪️Id
▪️FirstName
▪️LastName
▪️Email
▪️UserType
▪️Status
▪️JoinedAt
▪️LatestUpdatedAt
▪️PhoneNumber
▪️EmployeeNumber
▪️TicketCreatorNotificationsEnabled
▪️LatestFormSubmissionAt

Table includes: all items in Weever Database Manager

Columns included:

▪️DatabaseId
▪️DatabaseName
▪️TierId
▪️TierName
▪️TierLevel
▪️Id
▪️ParentId
▪️Name
▪️Note
▪️Status
▪️CreatedAt
▪️UpdatedAt

If you want to connect to your Weever Inspections data: 

Copy this URL to your clipboard: 

https://odata.weeverapps.com/v1/inspections

 

This URL will connect you to these tables: 

"ScheduledInspections" Table "Schedules" Table

Table includes: the datapoints included in the "All Inspections" view of the Scheduled Inspections page in Weever

Columns included:

▪️ScheduleId
▪️InspectionId
▪️InspectionTypeId
▪️InspectionTypeName
▪️AssetId
▪️AssetName
▪️FormId
▪️FormName
▪️FormSubmissionId
▪️ShiftId
▪️ShiftName
▪️AssigneeId
▪️AssigneeName
▪️ExpectedDurationMinutes
▪️TotalChecks
▪️PassedChecks
▪️FailedChecks
▪️NAChecks
▪️Status
▪️DueAt
▪️CompletedAt
▪️CompletedById
▪️CompletedByName
▪️UpdatedAt
▪️UpdatedById
▪️UpdatedByName

Table includes: the datapoints included in the "All Inspections" view of the Scheduled Inspections page in WeeverTable in

Columns Included: 

▪️ScheduleId
▪️InspectionTypeId
▪️InspectionTypeName
▪️AssetId
▪️AssetName
▪️FormId
▪️FormName
▪️ShiftId
▪️ShiftName
▪️AssigneeId
▪️AssigneeName
▪️Frequency
▪️DayOfWeek
▪️StartDate
▪️ExpectedDurationMinutes
▪️Status
▪️Note
▪️CreatedAt
▪️CreatedById
▪️CreatedByName
▪️UpdatedAt
▪️UpdatedById
▪️UpdatedByName

 

In Power BI desktop, tap "Get Data", then "OData Feed", then paste the OData URL in the OData field, and tap "OK". 

Adding OData URL

Step 2 - Add your company credentials

Tap "Organizational account" then tap the "Sign In" button. You will then be prompted to add your company email and password. Add that and then tap "Connect". 

Screenshot 2025-02-04 at 10.25.37 AM

 

Step 3 - Choose the tables to pull into your report

Each form will be in it's own table in this list. Tap the checkbox beside the form(s)/tables you want to load into Power BI and tap "Load". 

Power BI Navigator

And that's it! 

Now you can make timely reports with a live connection to your Weever data.