*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***
In this article, we'll show you how to export Power BI datasets to a connected SFTP site.
An SFTP data connection is an export of prebuilt Kallidus datasets to an SFTP location of your own. Once exported, you can extract and transform the data as needed before loading it into your external reporting tools.
A few things to know about SFTP connections:
- Only Users with permission to connect data will be able to create SFTP connections
- Each SFTP connection can export one or more datasets simultaneously
- Create as many SFTP connections as required
- You must have your own non-Kallidus SFTP location to successfully create a connection
- Dataset mapping schemas will help you establish the relationships between various dimension and fact tables
In this article, we'll cover steps to:
- Grant the Data Connector permission to a User
- Create an SFTP connection
- Review the delivery history of an SFTP connection
- Rerun a one-time SFTP connection
Steps to grant the Data Connector permission to a User
- Navigate to Manage users
- Search for the desired User
- Select Actions
- Select Edit:
- Scroll down to the Roles section
- Enable the Data connector permission. Note that this permission can be enabled independently of other reporting permissions. You don't have to enable the Reporting or Edit reports permissions for the User to successfully create data connections; however, you can enable them additionally if the User needs to view/edit reports:
Steps to create an SFTP connection
- Navigate to Reports
- Select Connect data
- Select New connection:
- Give the connection a name
- Add a description (optional):
- Select Next
- Select one or more datasets:
- Select Next
- Select an SFTP destination:
- Select Next
- Select a frequency:
- Select Save to complete the connection
Steps to review the delivery history for an SFTP connection
If you need to audit the delivery of your SFTP connections, or if you see an issue with any of your SFTP connections, you can easily review the delivery history. Here's how:
- Select Actions on any SFTP connection
- Select Delivery log:
- Find the relevant Timestamp and review the Status column:
Possible statuses are:
- Successful: All datasets were successfully generated and delivered to your SFTP location
- Failed: One or more datasets were not successfully generated, or all datasets were successfully generated but not successfully delivered to your SFTP location
- For "Failed" SFTP deliveries, click into the Status column to review the Data Connection Job ID. Provide this ID to our Support team and we'll help you troubleshoot.
Steps to rerun a one-time SFTP connection
For any one-time SFTP connections (those where the Schedule column shows "Now" or "Once"), you can rerun them at any time after their initial runs by selecting Actions and Run now:
Find out more about reporting and analytics with Microsoft Power BI
Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.
If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.
Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.
Comments
0 comments
Please sign in to leave a comment.