This section provides detailed information about the following topics:
- How to Connect
- Using the OData Feed (Cloud)
- Using SQL Server (On-Premise)
How to Connect
There are two options to connect to the data layer, depending on your edition of Barracuda Managed Workplace. Some common BI tools that can be used to connect are Power BI, Excel and Tableau.
Using the OData Feed (Cloud)
- In your BI tool, select the OData data source type
Type the URL to your OData feed, in the form of
https://<service center URL>/odata/v1, where
<service center URL>is the URL of your Service Center.
- When you are prompted for credentials, select Basic as the authentication mechanism.
- Type your Barracuda Managed Workplace VAR Domain\Username as the username and your password.
The user account must be in the Administrator role.
Using SQL Server (On-Premise)
- In your BI tool, select the SQL Server data source type.
When prompted for credentials, use the SCRptUser SQL login that was created for you when you deployed the rpt schema views.
Power BI Desktop Samples
Below are a collection of Power BI Destop samples that you can use for inspiration. These samples can be opened with Power BI Desktop only.
To Use a Sample
- Open Power BI Desktop.
- Open a template.
- While the data is loading, click Cancel.
- Select Edit Queries > Data Source Settings > Change Source.
- Change the connection to your specific data source.
Barracuda Branded Sample Template
To see an interactive graphic of the data model, click here.