Reduced Support Availability – 9th October 2025

Just a quick heads-up! On 9th October 2025, our support team will be attending the OneFile All Company 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!


Welcome to the new Help Centre! ✨

You may have spotted our new and shiny company website - and that’s not all that’s changed! We now have dedicated Help Centres for each of our products to make it easier for you to find the right support. For a quick guide to what’s new and where to go, click here.

Upcoming System Update: Enrol

On Tuesday 7th October 2025, we’ll be rolling out a series of enhancements to Enrol.

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

⏱️ Scheduled Downtime
Please note that there will be no service interruption.


Submit a ticket Log in

How to connect to the Data Exports (database tables)

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.