Scheduled Maintenance - Saturday 28th December 2024 7am - 8am

We will be migrating and upgrading our primary database server on Saturday 28th December 2024. This will require a maintenance window, during which services will be temporarily unavailable.

Click here for more information.

Please ensure your data is saved and you are logged out before 7am on 28th December. 


Software Update: Thursday 12th December 2024

On Thursday, we're updating OneFile Events and Enrol, to introduce some new enhancements and fixes.

Release notes can be found here.


Help centre

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

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.