The Skynamo Power BI Custom Connector
The Skynamo Power BI Custom connector allows for easy access to data from the four endpoints of the Skynamo Reporting API for use in Power BI. The connector connects to the Skynamo Reporting API using the provided credentials, transforms the resulting data into 18 tables that are shown in the Navigational table.
The once-off setup with regards to placement of the Skynamo Power BI custom connector file and trusting the signed connector is provided in the initial document sent with the connector file.
The rest of this document relates to the On-Premises Gateway, setting it up to be able to access the custom connectors, and adding a Gateway Cluster and data source on Power BI Service that can be assigned to a published report.
The Power BI on-premises data gateway provides organisations a way to keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services, such as Power BI Services.
Download and install
Download and install the gateway on a local computer. The gateway should, preferably, be installed on a computer that is on a wired network and always turned on.
- Download the standard gateway (also called an enterprise gateway).
- Enter the email address related to the Office 365 organization account, and select Sign in.
- Select Register a new gateway on this computer and click Next.
- Enter a name for the gateway. The name must be unique across the tenant. Also enter a recovery key. This key will be needed to recover or move the gateway. Select Configure.
- Review the information in the final window. Select Close.
Enable the use of custom connectors
Update On-premises data gateway settings to allow for custom connectors
- Open the On-premises data gateway app
- Navigate to Connectors
- In the Load custom data connectors from folder box, select a folder that can be accessed by the user running the gateway service or share the folder with the user. The default user is NT SERVICE\PBIEgwService
Power BI Service
Reports developed in Power BI Desktop with custom data connectors can be published to the Power BI Services. To be able to refresh these reports on the Power BI Services a Gateway cluster with a data source will be required.
- Create a Gateway Cluster
- Open Power BI Service
- Go to the Gateway Setting page
- Select Allow user’s custom data connectors to refresh through this gateway cluster (preview).
Add a data source to the Gateway Cluster
- Click on ADD DATA SOURCE
- Set the Data Source Type using the drop-down list. Set the value to Skynamo API Details
- Provide the connector with the required inputs
- Select Skip Test Connection
- Click on Add
Update data source of published report
- Create a report in Power BI Desktop
- Open Power BI Desktop
- Set the Skynamo Analytics Custom Connector as one of the data sources
- Create a report with visuals or just a blank report
- Publish the report to Power BI Service
- Update data source of published report on Power BI Service
- Open Power BI Service
- Go to Datasets
- Select My datasets
- Click on More options
- Expand Gateway connection section
- Check that the previously created Gateway cluster is shown (in this example it is called SkynamoAnalytics)
- Set the mapping to the data source that was previously created (in this example it is called ux Skynamo)
- Click on Apply
- If required, setup Scheduled refresh by scrolling down and expanding Scheduled refresh.