SumTotal
Note
The following connector article is provided by SumTotal, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the SumTotal website and use the support channels there.
Item | Description |
---|---|
Release State | General Availability |
Products | Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) |
Authentication types | SumTotal credentials using OAuth 2.0 |
You must have a SumTotal hosted environment with standard permissions to access the portal, and read permissions to access data in tables.
- Import
- Query Multiple OData endpoints
- Advanced
- Optionally filter records by RowVersionId parameter to get incremental data
Copy the SumTotal hosted root URL in full. This root URL is the unique URL specific to your instance. The URL will be in the format of https://<*yourcustomerdomain*>.sumtotal.host/
. Make sure not to copy the rest of the URL. Keep this URL somewhere handy so you can use it later.
Note
The Power Query SumTotal connector is currently only suited towards OData API endpoints. For more information, go to SumTotal's OData API functionality.
To connect to SumTotal from Power BI Desktop:
Select Get data from the Home tab.
In the Get Data dialog box, select Other > SumTotal, and then select Connect.
Enter the server URL address of the data you want to load.
Note
You'll be prompted with a script error, which loads JS/CSS scripts the login form uses. Select Yes.
When the table is loaded in Navigator, you'll be presented with the list of OData API entities that are currently supported by the connector. You can select to load one or multiple entities.
When you've finished selecting entities, select Load or Transform Data.
Note
If this is the first time you're connecting to this site, select Sign in and input your credentials. Then select Connect.
This section describes any issues or limitations associated with the SumTotal connector.
For information about OData API performance and throttling limits for SumTotal connections, go to SumTotal's OData API functionality under the Important Notes section. These limitations apply to both the SumTotal connector (which uses the OData API as an implementation detail) and the 'actual' OData Hosted API when accessing the same endpoints.
As a guideline, most default tables are retrieved at approximately 1000 rows per second using the SumTotal connector. If you require faster retrieval rates, consider using the RowVersionId filter parameter. You can pass this parameter directly to the environment hosted URL by appending it as a query string parameter. Full URL example with rowVersionId parameter: https://{host}.sumtotalystems.com/?rowVersionId=1234
.