Reduced Support Availability – 19th January 2026

Just a quick heads-up! On 19th January 2026, our support and qualifications team will be attending a  Training and Development Meeting, so our response times may be a little slower than usual. 

But don’t worry — you can still find answers quickly by searching our Help Centre for guides and FAQs. If you need further assistance, feel free to submit a ticket. and we’ll get back to you as soon as we can.

If your issue is urgent, please make sure to set the priority accordingly when submitting your request.

Thanks for your understanding!

Upcoming System Update: Eportfolio & Learning Journal

On Wednesday 21st January 2026, we’ll be rolling out a series of enhancements and fixes to Eportfolio.

Release Notes
Full details of the changes can be found here.  

⏱️ Scheduled Downtime
Please note that there will be a brief service interruption between 07:00 and 07:30 AM on the day of the update.

⚠️Action Required
To avoid any data loss, make sure you’re logged out and have saved all work before 07:00 AM.


Upcoming System Update: Enrol and RPL

On 16th January 2026, we’ll be rolling out a series of improvements to Enrol and RPL.

Full details of the changes can be found in the release notes below:

Downtime: There will be no product downtime.

Submit a ticket Log in
  1. Home
  2. Guides and Support
  3. Eportfolio Reports
  4. OneFile Data Exports

How to connect to the Data Exports (database tables)

Adam Fogo
Modified on: Tue, 7 Oct, 2025 at 9:30 AM

Welcome to the guide for connecting to your OneFile BI Database. This guide is designed to ensure a smooth and secure connection process. To begin, you will need the specific credentials and database name that will be provided to you by our support team, once your organisation had purchased the Data Export (database tables). These credentials are essential for authenticating and providing read-only access to your database.

You have the flexibility to use various tools or applications to establish the connection, such as Power BI, SQL Server Management Studio (SSMS), Azure Data Studio, or any other database client that you prefer. Each of these tools offers a user-friendly interface to help you view and analyse your data effectively.

The details required to connect are:

  • Server Type: Database Engine (if required)
  • Server Name: onefilebi.database.windows.net
  • Database Name:provided by the support team
  • Username: provided by the support team
  • Password:provided securely by the support team

Important

To connect to the database, please make sure access to onefilebi.database.windows.net has been granted on port 1433.

To test whether the port is open, run the following command in Windows PowerShell

Test-NetConnection -ComputerName onefilebi.database.windows.net -Port 1433

See below for step by step guidance for the examples provided:

Power BI SQL (SSMS)
  1. In PowerBI, click Get Data
  2. Click Azure
  3. Click Azure SQL Database
  4. Enter the Server Name and Database Name

  5. Click OK

  6. Click Database

  7. Enter the provided Username and Password

  8. Click Connect

You will now be able to see the available database tables to import, on the PowerBI Navigator screen:

Table Relationships in PowerBI:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Other Guides